Re: Error in returning setof records

From: Richard Huxton <dev(at)archonet(dot)com>
To: Anjali Arora <anjalia(at)cdac(dot)in>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: Error in returning setof records
Date: 2006-04-27 15:16:34
Message-ID: 4450E052.7070309@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Bruce Momjian 2006-04-27 22:31:34 Re: [BUGS] BUG #2401: spinlocks not available on amd64
Previous Message Bruce Momjian 2006-04-27 02:41:48 Re: prepare-alter-exec issue