[soci-users] Call PL/pgSQL function that receives a ROWTYPE.

[Erasmo Aguilera]

Hello,



Somebody knows if it is possible to call a PL/pgSQL function that receives a
ROWTYPE argument (e.g., employees%ROWTYPE), from SOCI?



Erasmo.

[Mateusz Loskot]

Post by Erasmo Aguilera
Somebody knows if it is possible to call a PL/pgSQL function that receives a
ROWTYPE argument (e.g., employees%ROWTYPE), from SOCI?

I have never used this feature myself.
There is no trace of ROWTYPE-specific implementations in SOCI.
I also don't see anything in the test for ROWTYPE.
However, it might work - you need to experiment.

BTW, AFAIU, ROWTYPE specifier is redundant in PostgreSQL:

"Since every table has an associated composite type of the same name,
it actually does not matter in PostgreSQL whether you write %ROWTYPE or not.
But the form with %ROWTYPE is more portable"

Best regards,