Re: [GENERAL] handling out parameter

2010-06-04 Thread Pavel Stehule
Hello 2010/6/4 Ravi Katkar : > Hi , > > > > I have below function adf with inout, out parameter , > > > > CREATE OR REPLACE FUNCTION adf(inout voutvar integer , out vVar integer) > >  AS > > $BODY$ > > BEGIN > >   voutvar := 20; > >   vvar := 10; > > RETURN; > > END; $BODY$ > >   LANGUAGE 'plpgsql

[GENERAL] handling out parameter

2010-06-04 Thread Ravi Katkar
Hi , I have below function adf with inout, out parameter , CREATE OR REPLACE FUNCTION adf(inout voutvar integer , out vVar integer) AS $BODY$ BEGIN voutvar := 20; vvar := 10; RETURN; END; $BODY$ LANGUAGE 'plpgsql' After compiling I get below signature of function adf(integer) and return