From: | Patrick Welche <prlw1(at)newn(dot)cam(dot)ac(dot)uk> |
---|---|
To: | Mauricio Hipp Werner <mhipp(at)mail(dot)pjud(dot)cl> |
Cc: | Alexaki Sofia <alexaki(at)ics(dot)forth(dot)gr>, pgsql-sql(at)postgresql(dot)org, Markus Wagner <wagner(at)imsd(dot)uni-mainz(dot)de>, pgsql-interfaces(at)postgresql(dot)org |
Subject: | Re: outer join in PostgreSql |
Date: | 2001-01-15 21:36:53 |
Message-ID: | 20010115213653.D8984@quartz.newn.cam.ac.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-interfaces pgsql-sql |
On Mon, Jan 15, 2001 at 06:16:00PM -0400, Mauricio Hipp Werner wrote:
> I need help, which is the symbol used in postgreSql to carry out the outer
> join.
>
> in oracle the is used (+)
> in sybase the is used * and
> in postgreSql?
I don't really understand your question, but from src/test/regress/sql/join.sql
some examples of use are:
--
-- Outer joins
-- Note that OUTER is a noise word
--
SELECT '' AS "xxx", *
FROM J1_TBL LEFT OUTER JOIN J2_TBL USING (i);
SELECT '' AS "xxx", *
FROM J1_TBL LEFT JOIN J2_TBL USING (i);
SELECT '' AS "xxx", *
FROM J1_TBL RIGHT OUTER JOIN J2_TBL USING (i);
SELECT '' AS "xxx", *
FROM J1_TBL RIGHT JOIN J2_TBL USING (i);
SELECT '' AS "xxx", *
FROM J1_TBL FULL OUTER JOIN J2_TBL USING (i);
SELECT '' AS "xxx", *
FROM J1_TBL FULL JOIN J2_TBL USING (i);
SELECT '' AS "xxx", *
FROM J1_TBL LEFT JOIN J2_TBL USING (i) WHERE (k = 1);
SELECT '' AS "xxx", *
FROM J1_TBL LEFT JOIN J2_TBL USING (i) WHERE (i = 1);
Cheers,
Patrick
From | Date | Subject | |
---|---|---|---|
Next Message | Mauricio Hipp Werner | 2001-01-15 22:16:00 | outer join in PostgreSql |
Previous Message | Jim Di Crescenzo | 2001-01-15 20:33:05 | PQexec |
From | Date | Subject | |
---|---|---|---|
Next Message | Mauricio Hipp Werner | 2001-01-15 22:16:00 | outer join in PostgreSql |
Previous Message | Johann Spies | 2001-01-15 20:13:25 | pg_dump error |