Neil Conway wrote:
> On Wed, 2003-10-22 at 13:26, Bruce Momjian wrote:
> > > * Cause FETCH 1 to return the next cursor row, or zero if at
> > ----
> > > beginning/end of cursor, per SQL spec (Bruce)
>
> That's better, but still wrong: what does it mean for FETCH 1 to "return
> zero if at the beginning/end of cursor"? If we're at the end of the
> cursor, we return an empty result set, not "zero".
Yes, it is mixing the return row with the return value of zero --- hence
we need to revisit this. I can't even remember how this is different
from 7.3. I remember applying these changes at the direction of others,
and not fully understanding all the issues.
--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073