Tom Lane wrote:
>
> "K. Ari Krupnikov" <ari@iln.net> writes:
> > Many queries can be formulated as either a self-join or a subquery on
> > the same table.
> > Is there any difference in performance, or does the analyzer treat them
> > the same?
>
> You're a lot better off with a self-join, at present.
At present - is there a change planned?
Could you elaborate a little on how such queries are expanded?
--
K. Ari Krupnikov
DBDOM - bridging XML and relational databases
http://www.iter.co.il