| From: | Doug McNaught <doug(at)wireboard(dot)com> |
|---|---|
| To: | "Campano, Troy" <Troy(dot)Campano(at)LibertyMutual(dot)com> |
| Cc: | "Pgsql-General (pgsql-general(at)postgresql(dot)org)" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: PostgreSQL Outer Joins |
| Date: | 2001-12-10 18:58:33 |
| Message-ID: | m3g06i52cm.fsf@belphigor.mcnaught.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
"Campano, Troy" <Troy(dot)Campano(at)LibertyMutual(dot)com> writes:
> Does PostgreSQL 7.1.3 support outer joins; or do you still need to use
> subqueries?
Yes, it supports outer joins.
> If it does support outer joins, does anyone know the syntax?
Same syntax as the SQL standard I think (as opposed to Oracle's which
is nonstandard). See the docs:
http://www.us.postgresql.org/users-lounge/docs/#7.1
-Doug
--
Let us cross over the river, and rest under the shade of the trees.
--T. J. Jackson, 1863
| From | Date | Subject | |
|---|---|---|---|
| Next Message | wsheldah | 2001-12-10 18:59:25 | Re: PostgreSQL Outer Joins |
| Previous Message | Doug McNaught | 2001-12-10 18:56:06 | Re: problem with select after updating |