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
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? |