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