"Gregor Zeitlinger" <gregor(dot)zeitlinger(at)torexretail(dot)de> writes:
> select * from T1 join T2 on T1.id =3D T2.id LIMIT 1
> Conceptually, it should be possible to fetch one row from T1 and T2, =
> i.e. to propagate the LIMIT clause.
> I was wondering what the exact requirements are to propagate the LIMIT =
Indexes would help ...
regards, tom lane
In response to
pgsql-hackers by date
|Next:||From: Andrew Dunstan||Date: 2006-02-22 16:12:22|
|Subject: Re: windows / initdb oddness|
|Previous:||From: Gregor Zeitlinger||Date: 2006-02-22 15:41:37|
|Subject: LIMIT and JOINS|