Re: SQL:2008 LIMIT/OFFSET

Tom Lane wrote:
> Peter Eisentraut <peter_e(at)gmx(dot)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.