Skip site navigation (1) Skip section navigation (2)

Re: A question about Join?...

From: "Goulet, Dick" <DGoulet(at)vicr(dot)com>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: Re: A question about Join?...
Date: 2004-06-23 17:24:29
Message-ID: 4001DEAF7DF9BD498B58B45051FBEA650146C418@25exch1.vicorpower.vicr.com (view raw or flat)
Thread:
Lists: pgsql-admin
BTW for those interested Oracle 9i also uses the LEFT, RIGHT, and OUTER join syntax as well.

Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA

-----Original Message-----
From: Stephan Szabo [mailto:sszabo(at)megazone(dot)bigpanda(dot)com]
Sent: Wednesday, June 23, 2004 12:54 PM
To: Jhonatas M. Rodríguez
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: [ADMIN] A question about Join?...


On Wed, 23 Jun 2004, [iso-8859-1] Jhonatas M. Rodríguez wrote:

> Hello Everybody?...
>
>
>
>    Hey, i have a question about of the uses the joins
> in PostgreSQL.
>
> In SQL Server the joins i can use with the simbol(*),
> Example:. the right join is "field1=*field2"
>
> In Oracle the joins are with the simbol (+),
> Example:. the left join is "field1(+)=field2"
>
> What is the simbol the PostgreSQL in the use the
> JOINS?....

PostgreSQL uses the SQL standard syntax for outer joins.

Things like:
 table1 LEFT JOIN table2 ON (table1.field1 = table2.field2)
 table2 RIGHT OUTER JOIN table1 ON (table2.field2 = table1.field1)

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)

pgsql-admin by date

Next:From: Jón RagnarssonDate: 2004-06-23 17:29:22
Subject: Stupid mistake: Forgot to dump when upgrading. (7.3 -> 7.4.2)
Previous:From: Chris White (cjwhite)Date: 2004-06-23 17:11:45
Subject: Problems restoring tables using 7.4.2

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group