[GENERAL] stored proc help

2005-07-13 Thread Jason Tesser
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? CREATE OR REPLACE FUNCTION public.irispermissionget (username varchar,

Re: [GENERAL] stored proc help

2005-07-13 Thread Michael Fuhr
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