Re: Negative LIMIT and OFFSET?

Gregory Stark <stark@enterprisedb.com> writes:
> "Tom Lane" <tgl@sss.pgh.pa.us> writes:
>> This behavior suggests that they can't even deal with LIMIT/OFFSET
>> values that aren't simple integer literals ...

> I suppose when they added these features I think they didn't have subqueries,
> so there wasn't really much useful that could be done with arbitrary
> expressions here. Being able to do "LIMIT 1+1" doesn't actually add anything.

Sure.  I think our first implementation of LIMIT was similarly
constrained.  It's just amusing that they haven't moved past that,
despite having had the feature first ...

			regards, tom lane