On Wed, Jul 13, 2005 at 01:28:45PM -0500, Jason Tesser wrote:
> I have the following store dproc but when I run it I am getting the
> error
>
> ERROR: invalid input syntax for integer: "(1)"
> CONTEXT: PL/pgSQL function "irispermissionget" line 9 at return next
>
> What am I doing wrong?
The function is declared to return SETOF INTEGER, but you return a
RECORD variable:
> return next returnRec;
Try returning returnRec.permissionid instead.
--
Michael Fuhr
http://www.fuhr.org/~mfuhr/