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 execute your 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(dot)n(dot)connah(at)protonmail(dot)com>
Sent: 30 Mart 2021 Salı 11:23
To: pgsql-novice(at)lists(dot)postgresql(dot)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 to work 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't working. 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.