"K. Ari Krupnikov" <[EMAIL PROTECTED]> 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. regards, tom lane