From: | Chris Curvey <chris(at)chriscurvey(dot)com> |
---|---|
To: | pgsql <pgsql-general(at)postgresql(dot)org> |
Subject: | replacing a subquery with an outer join? |
Date: | 2011-07-22 01:20:21 |
Message-ID: | CADfwSsA6GVdRDLMsa+dau95FE7GiJD-ZEwHxyszT5Bi-D4Ztww@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
in an earlier thread, the following query was submitted:
SELECT COUNT(*) FROM q
> WHERE NOT EXISTS (SELECT 1
> FROM t AS t
> WHERE t.mid = q.mid);
and as part of his answer, David Johnson responded
3. Also, you are using a correlated sub-query instead of a LEFT OUTER JOIN
This interests me. How would you rewrite the correlated subquery above
using the outer join?
--
e-Mail is the equivalent of a postcard written in pencil. This message may
not have been sent by me, or intended for you. It may have been read or
even modified while in transit. e-Mail disclaimers have the same force in
law as a note passed in study hall. If your corporate attorney says that
you need an disclaimer in your signature, you need a new corporate attorney.
From | Date | Subject | |
---|---|---|---|
Next Message | Gavin Flower | 2011-07-22 01:45:40 | Re: replacing a subquery with an outer join? |
Previous Message | Devrim GÜNDÜZ | 2011-07-21 22:09:00 | Re: PostgreSQL 8.4.8 RPM/SRPM for RHEL4 |