Anjali Arora wrote:
> Hi all,
> when i am returning function as setof record then it will give error
> "ERROR: set-valued function called in context that cannot accept a set
> CONTEXT: PL/pgSQL function "gfs_ls" while casting return value to
> function's return type"
This is not a bug - see the manuals for details.
A set returning function is like a table so you need to call it as:
SELECT * FROM my_set_function();
For general help you might like to try the general/sql mailing lists
rather than the bug tracker.
In response to
pgsql-bugs by date
|Next:||From: Bruce Momjian||Date: 2006-04-27 22:31:34|
|Subject: Re: [BUGS] BUG #2401: spinlocks not available on amd64|
|Previous:||From: Bruce Momjian||Date: 2006-04-27 02:41:48|
|Subject: Re: prepare-alter-exec issue|