pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Returning rows from functions
2+ messages / 2 participants
[nested] [flat]

* Returning rows from functions
@ 2002-07-11 00:37 David Durst <ddurst@la-rubber.com>
  2002-07-11 04:59 ` Re: Returning rows from functions Joe Conway <mail@joeconway.com>
  0 siblings, 1 reply; 2+ messages in thread

From: David Durst @ 2002-07-11 00:37 UTC (permalink / raw)
  To: pgsql-sql

I was wondering if there was a way of returning a complete row from a
function, in reading the documentation of CREATE FUNCTION. I was under the
impression that you could return a row by using setof, but this does not
seem to be true.
Can anyone help?





^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: Returning rows from functions
  2002-07-11 00:37 Returning rows from functions David Durst <ddurst@la-rubber.com>
@ 2002-07-11 04:59 ` Joe Conway <mail@joeconway.com>
  0 siblings, 0 replies; 2+ messages in thread

From: Joe Conway @ 2002-07-11 04:59 UTC (permalink / raw)
  To: David Durst <ddurst@la-rubber.com>; +Cc: pgsql-sql

David Durst wrote:
> I was wondering if there was a way of returning a complete row from a
> function, in reading the documentation of CREATE FUNCTION. I was under the
> impression that you could return a row by using setof, but this does not
> seem to be true.
> Can anyone help?

The short answer is "yes, but..."; see the thread at:
     http://archives.postgresql.org/pgsql-interfaces/2002-06/msg00042.php
for a recent discussion about this.

HTH,

Joe




^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2002-07-11 04:59 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2002-07-11 00:37 Returning rows from functions David Durst <ddurst@la-rubber.com>
2002-07-11 04:59 ` Joe Conway <mail@joeconway.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox