Re: Variable LIMIT and OFFSET in SELECTs

On 11/16/07, Reg Me Please <regmeplease(at)gmail(dot)com> wrote:
> Il Friday 16 November 2007 08:33:14 Tom Lane ha scritto:

> > Let me try to explain one more time. You propose allowing
> >
> > select ... from
> > table1 join table2 on table1.x = table2.y
> > limit table1.z
> >
> > Now this would be somewhat well-defined if there were only one row in
> > table1, or if there were many rows but they all had the same value
> > in column z. But what if that's not the case? If there are multiple
> > possible values for z then the query is just not sensible.

> tmp=# SELECT * from nextval( (select seq from seqs) );
> ERROR: more than one row returned by a subquery used as an expression

This is a subselect, not a column from the query itself. Completely
different thing.