Re: functions returning sets - Mailing list pgsql-general

From Tom Lane
Subject Re: functions returning sets
Date
Msg-id 17389.1071535207@sss.pgh.pa.us
Whole thread Raw
In response to Re: functions returning sets  (Jeff Rogers <jrogers@findlaw.com>)
Responses Re: functions returning sets
Re: functions returning sets
Re: functions returning sets
List pgsql-general
Jeff Rogers <jrogers@findlaw.com> writes:
> I expect this latter to return all the ids, but it seems to only return every
> other one.

Hmm, this looks like a bug having to do with not resetting state
correctly for the next invocation of the SRF.  Hard to tell whether
the bug is in your code or the system's support for SRFs though.

Joe, did you see
http://archives.postgresql.org/pgsql-general/2003-12/msg00709.php
?  I don't have time to look at this right now ...

            regards, tom lane

pgsql-general by date:

Previous
From: Jeff Rogers
Date:
Subject: Re: functions returning sets
Next
From: Joe Conway
Date:
Subject: Re: functions returning sets