Re: [GENERAL] out parameter and setof record

2006-05-30 Thread A. Kretschmer
am 30.05.2006, um 3:21:27 -0700 mailte [EMAIL PROTECTED] folgendes: > In PostgreSql 8.1 i've tried to use Out parameter but when I've changed > function (added Out parameter) > ... > > ERROR: function result type must be integer because of OUT parameters > > > Of course when I change

[GENERAL] out parameter and setof record

2006-05-30 Thread uran1
In PostgreSql 8.1 i've tried to use Out parameter but when I've changed function (added Out parameter) CREATE OR REPLACE FUNCTION reffunc3(FROM_ID in integer,COUNT_ROW OUT integer) RETURNS SETOF Person AS ' DECLARE rec RECORD; BEGIN SELECT count(*) INTO