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