Re: [SQL] plpgsql out parameter with select into

It don't work... Only select into status * from... works. Imre Horvath 2010. 08. 18, szerda keltezéssel 09.42-kor Sergey Konoplev ezt írta: > Hi, > > SELECT column_name > INTO var_name > FROM ... > > 2010/8/17 Horváth Imre : > > Hi! > >

[SQL] plpgsql out parameter with select into

$ select into status * from testfunc1(); $BODY$ language plpgsql; create function testfunc3() as declare status integer; $BODY$ select into status _status from testfunc1(); $BODY$ language plpgsql; testfunc2 works, testfunc3 not. Thanks in advance: Imre Horvath -- Sent via

[SQL] type cast

stfunc(unknown) does not exist HINT: No function matches the given name and argument types. You might need to add explicit type casts. Thanks in advance: Imre Horvath -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql

[SQL] pl/python out params

test func is: create or replace function outtest(out i integer, out j text) returns boolean as $BODY$ i = 1 j = 'something' return True $BODY$ language plpythonu; Thanks in advance: Imre Horvath -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to you