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.