From: | Sam Mason <sam(at)samason(dot)me(dot)uk> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Variable LIMIT and OFFSET in SELECTs |
Date: | 2007-11-16 06:53:49 |
Message-ID: | 20071116065349.GJ1955@frubble.xen.chris-lamb.co.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Fri, Nov 16, 2007 at 01:38:30AM -0500, Tom Lane wrote:
> Sam Mason <sam(at)samason(dot)me(dot)uk> writes:
> > wow, that's kind of fun isn't it. I only thought you could put a
> > constant in there. Maybe I should have had a look in the grammar/tested
> > it first!
>
> IIRC, it used to be restricted to a constant, a few revisions back.
> In current releases the only restriction that stems from laziness is
> not allowing a sub-select. (If anyone were to put forward a serious
> use-case, we'd probably go fix that.)
I'm amazed it supports anything more than a constant. The values are
almost always going to come from external code, so there doesn't seem
much point in doing anything else.
I suppose with all the expression evaluation code already in PG,
supporting what it currently does isn't hard.
> The OP's complaint is that we don't allow a variable of the query's own
> level, but AFAICT he's still not grasped the point that that leads to an
> indeterminate limit value ...
Being too close to a problem makes it very easy to forget about the
general case. I probably do this far too often myself!
Sam
From | Date | Subject | |
---|---|---|---|
Next Message | Reg Me Please | 2007-11-16 07:12:24 | Re: Variable LIMIT and OFFSET in SELECTs |
Previous Message | Tom Lane | 2007-11-16 06:38:30 | Re: Variable LIMIT and OFFSET in SELECTs |