Re: functions returning records

Alex Pilosov wrote:
>
> On Tue, 26 Jun 2001, Reinoud van Leeuwen wrote:
>
> > Coming from a Sybase environment I would love to have functions return
> > a result set. A few things to think of:
> > 1: will it be possible to return multiple result sets? (in Sybase any
> > select statement that is not redirected to variables or a table goes
> > to the client, so it is quite common to do multiple selects). Does the
> > postgresql client library support this?
> No, libpq protocol cannot support that. This is really a sybasism, as good
> as it is, no other database supports anything like that.

IIRC the _protocol_ should support it all right, but the current libpq
implementation does not (and the sql queries in functions are not sent
to
client either)

---------------
Hannu