On Sun, Oct 25, 2026 at 4:50 AM Mark <[email protected]> wrote:

> If I run \df getsSessDbKey I get:
> Schema |     Name     | Result data type |
>                                                 Argument data types
>                                                 | Type
>
> --------+--------------+------------------+--------------------------------------------------------------------------------------------------------------------+------
> public | getsessdbkey | record           | isessionid text, iuser text,
> ifunction text, OUT osessdbkey bigint, OUT osessret customtype, OUT
> retsessdbmess text | func
>

> Any pointers into how I can find out more about this error or hints on how
> to resolve this would be heavily appreciated?
>

Show the code you actually wrote.  If you cannot do that, write similar
code that produces the same error and show that.

For that function you'd probably write something like:

select osessdbkey, osessret, retsessdbmess
into var1, var2, var3
from getsSessDbKey(isessionid, iuser, ifunction);

to execute the function and capture the three output fields.

David J.

P.S. As for the 'memory locations' comment - that seems like something you
misunderstood and thus acted upon unnecessarily.

Reply via email to