Re: [SQL] function returning a cursor and a scalar

2009-07-14 Thread Surajit Bhattacharjee
July 13, 2009 2:22 PM To: Surajit Bhattacharjee Cc: pgsql-sql@postgresql.org Subject: Re: [SQL] function returning a cursor and a scalar Surajit Bhattacharjee wrote: > I am new to Postgresql and am trying to write a function which will do a > search and return the first page of results along

Re: [SQL] function returning a cursor and a scalar

2009-07-13 Thread Alvaro Herrera
Surajit Bhattacharjee wrote: > I am new to Postgresql and am trying to write a function which will do a > search and return the first page of results along with the total number > of matches. How can I make my function return a cursor AND a scalar - > can I do the scalar as an OUT param and then ma

[SQL] function returning a cursor and a scalar

2009-07-12 Thread Surajit Bhattacharjee
I am new to Postgresql and am trying to write a function which will do a search and return the first page of results along with the total number of matches. How can I make my function return a cursor AND a scalar - can I do the scalar as an OUT param and then make the function explicitly RETURN a r