Re: SQL:2008 LIMIT/OFFSET

Tom Lane wrote:
> Peter Eisentraut <peter_e@gmx.net> writes:
>> SQL:2008 specifies the following syntax for what we have so far called 
>> LIMIT and OFFSET
>> SELECT ... [ ORDER BY ... ]
>>      OFFSET num {ROW|ROWS} FETCH {FIRST|NEXT} [num] {ROW|ROWS} ONLY
> 
> What does the "NEXT" option mean?

FIRST and NEXT mean exactly the same, namely nothing.

> BTW, I think it's a bad idea to assign made-up parse locations, as
> you did here:
> 
>> +            | /*EMPTY*/        { $$ = makeIntConst(1, @$); }
> 
> Just use -1.

Hmm, @$ is the location of the complete rule, so it should point to the
"empty" spot in theory.  Or am I misunderstanding something?

It's hard to simulate an error with this of course.