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 ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
