On Tue, Feb 22, 2005 at 04:29:30PM -0700, Steve - DND wrote: > Can a function return two type results? So that the first type would be just > the total number of records, and the second type would be the resultset of > customers?
The function could return a set of cursors, one for the query that returns the total number of records and one for the resultset. The 8.0 documentation has an example that should work in earlier versions as well (except for the dollar quoting): http://www.postgresql.org/docs/8.0/static/plpgsql-cursors.html See the example at the bottom of the page. -- Michael Fuhr http://www.fuhr.org/~mfuhr/ ---------------------------(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
