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/ ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
