Re: [SQL] move forward 0 from foo;

2004-03-23 Thread Tom Lane
Chester Kustarz <[EMAIL PROTECTED]> writes: > I expected "MOVE FORWARD 0 FROM foo;" to always return > 0, but I have found this not to be the case. You are misinterpreting the output. The result is the number of rows that would have been returned by a FETCH with the same parameters. FETCH 0 means

[SQL] move forward 0 from foo;

2004-03-23 Thread Chester Kustarz
I expected "MOVE FORWARD 0 FROM foo;" to always return 0, but I have found this not to be the case. Could anybody comment whether this is expected: mow=# begin; BEGIN mow=# create table a (a integer); CREATE TABLE mow=# insert into a values ( 1 ); INSERT 1823482 1 mow=# insert into a values ( 1 );