RE: [EXTERNAL] Calling stored procedures and functions

Hi Simon,

I think you need to read more on the differences between PostgreSQL functions and procedures. I suggest you use CALL to
executeyour procedure, instead of a SELECT.
 

You can also change the procedure into a function and that will also work.

The syntax is:
CALL proc(...)
or
SELECT func(...)

See https://www.postgresql.org/docs/current/sql-call.html for more info.

-----Original Message-----
From: Simon Connah <simon.n.connah@protonmail.com> 
Sent: 30 Mart 2021 Salı 11:23
To: pgsql-novice@lists.postgresql.org
Subject: [EXTERNAL] Calling stored procedures and functions

Hi,

I'm really sorry to ask so many questions in such a short period of time but I'm having some issues with getting things
towork and Google isn't working too well for me at the moment. At least I am doing what Google tells me but it still
isn'tworking. Anyway, my code is here (along with the error message):
 

https://gist.github.com/simonconnah/4ea902ca9830caafd3901dea0f84b49f

If anyone could shed some light on why calling this stored procedure isn't working I would really appreciate it.

Thank you.

Simon.