> -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of > Rikard Pavelic > Sent: 16 January 2006 15:02 > To: pgadmin-support@postgresql.org > Subject: [pgadmin-support] procedure properties problem > > Hi! > I don't know if this is missing feature or bug, but just to > report this. > > If I create functions like > create or replace function example(out data varchar) returns > setof record as > $$ > select data from table > $$ language sql; > > pgAdmin displays it without 'returns setof record'.
The function written above will never work as you have a mismatch of parameter and return types, but in answer to your query, the PostgreSQL docs say: "When there are OUT or INOUT parameters, the RETURNS clause may be omitted." (http://www.postgresql.org/docs/8.1/interactive/sql-createfunction.html) If you remove the OUT/INOUT parameters, pgAdmin will display the definition with the RETURNS SETOF clause. Regards, Dave. ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
