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
