Re: Return Value of a Function

From: elein <elein(at)varlena(dot)com>
To: Joe Conway <mail(at)joeconway(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Terry Lee Tucker <terry(at)esc1(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Return Value of a Function
Date: 2004-02-08 23:35:04
Message-ID: 20040208153504.I30125@cookie.varlena.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I have some light examples in
http://www.varlena.com/GeneralBits/Tidbits
based on Stephan's.

The discussion in issue
http://www.varlena.com/GeneralBits/24.html
shows the differences between setof and rows.

--elein

On Mon, Feb 02, 2004 at 09:47:11AM -0800, Joe Conway wrote:
> Tom Lane wrote:
> >(Joe, I couldn't find a self-contained example using a function-returning-
> >record after a bit of searching in the 7.4 docs. Surely there is one?)
>
> Looks like only one (see bottom of "Examples" section):
> http://www.postgresql.org/docs/current/static/sql-select.html
> Probably could use more examples somewhere.
>
> We frequently direct people to Stephan Szabo's "Set Returning Functions"
> page on Techdocs:
> http://techdocs.postgresql.org/guides/SetReturningFunctions
>
> Joe
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: the planner will ignore your desire to choose an index scan if your
> joining column's datatypes do not match

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Alex Satrapa 2004-02-08 23:46:43 Re: Foreign Key on Inheriting Table?
Previous Message elein 2004-02-08 23:30:29 Re: application developers list?? or report engine using postgres?