On Tuesday, March 30th, 2021 at 09:32, Hanefi Onaldi <Hanefi.Onaldi@microsoft.com> wrote:
> Hi Simon,
>
> I think you need to read more on the differences between PostgreSQL functions and procedures. I suggest you use CALL
toexecute 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.
>
Thank you! I was getting them the wrong way around. Everything seems to be working now. I really appreciate your help.
Simon.