Re: [GENERAL] Function to return both integer and SETOF refcursor

2008-05-16 Thread Tom Lane
Chuck Bai <[EMAIL PROTECTED]> writes: > I got the following error when try to create a function to return an > integer and SETOF refcursor. You can't. Perhaps it'd be enough to return the same integer value in each row of the output? regards, tom lane -- Sent via pgsql

[GENERAL] Function to return both integer and SETOF refcursor

2008-05-16 Thread Chuck Bai
I got the following error when try to create a function to return an integer and SETOF refcursor. I want to get refcursors back along with an Out parameter in one function. There seems to be a conflict on return type. How do I fix it? Thanks. ERROR: function result type must be integer becaus