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"

plz help me to get rid of it

--
With Regards,
Anjali Arora
Project Engineer
Hardware Technology And Development Group
Center for Development of Advanced Computing
Pune University Campus,Ganeshkhind
Pune-411007
Tel: 020-25704320
Mob: 09372441025
Web: www.cdac.in




---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

Anjali Arora wrote:
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

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match