Re: Error in returning setof records

[Richard Huxton <dev(at)archonet(dot)com>]

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.
--
  Richard Huxton
  Archonet Ltd