pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedRe: outer join in PostgreSql
7+ messages / 7 participants
[nested] [flat]
* Re: outer join in PostgreSql
@ 2001-01-15 21:36 Patrick Welche <prlw1@newn.cam.ac.uk>
parent: Mauricio Hipp Werner <mhipp@mail.pjud.cl>
3 siblings, 0 replies; 7+ messages in thread
From: Patrick Welche @ 2001-01-15 21:36 UTC (permalink / raw)
To: Mauricio Hipp Werner <mhipp@mail.pjud.cl>; +Cc: Alexaki Sofia <alexaki@ics.forth.gr>; pgsql-sql@postgresql.org, Markus Wagner <wagner@imsd.uni-mainz.de>; pgsql-interfaces
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
^ permalink raw reply [nested|flat] 7+ messages in thread
* outer join in PostgreSql
@ 2001-01-15 22:16 Mauricio Hipp Werner <mhipp@mail.pjud.cl>
0 siblings, 4 replies; 7+ messages in thread
From: Mauricio Hipp Werner @ 2001-01-15 22:16 UTC (permalink / raw)
To: Alexaki Sofia <alexaki@ics.forth.gr>; pgsql-sql@postgresql.org; Markus Wagner <wagner@imsd.uni-mainz.de>; +Cc: pgsql-interfaces
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?
thank you
Hipp Mauricio
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: [INTERFACES] outer join in PostgreSql
@ 2001-01-15 22:21 Peter Eisentraut <peter_e@gmx.net>
parent: Mauricio Hipp Werner <mhipp@mail.pjud.cl>
3 siblings, 0 replies; 7+ messages in thread
From: Peter Eisentraut @ 2001-01-15 22:21 UTC (permalink / raw)
To: Mauricio Hipp Werner <mhipp@mail.pjud.cl>; +Cc: pgsql-sql@postgresql.org
Mauricio Hipp Werner writes:
> 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?
No symbol, just words.
http://www.postgresql.org/devel-corner/docs/postgres/sql-select.htm
--
Peter Eisentraut peter_e@gmx.net http://yi.org/peter-e/
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: outer join in PostgreSql
@ 2001-01-16 05:12 Thomas Lockhart <lockhart@alumni.caltech.edu>
parent: Mauricio Hipp Werner <mhipp@mail.pjud.cl>
3 siblings, 1 reply; 7+ messages in thread
From: Thomas Lockhart @ 2001-01-16 05:12 UTC (permalink / raw)
To: Mauricio Hipp Werner <mhipp@mail.pjud.cl>; +Cc: Alexaki Sofia <alexaki@ics.forth.gr>; pgsql-sql@postgresql.org, Markus Wagner <wagner@imsd.uni-mainz.de>; pgsql-interfaces
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?
The PostgreSQL outer join is accomplished using SQL92 syntax. You will
not find real outer joins *except* in the current beta release, and
beware that there may be some tweaks to the grammar to help with
conformance to the standard.
In any case, check the standard or try something like "select * from t1
left outer join t2 on (i)".
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: outer join in PostgreSql
@ 2001-01-16 15:17 Borek Lupoměský <borekl@volny.cz>
parent: Mauricio Hipp Werner <mhipp@mail.pjud.cl>
3 siblings, 0 replies; 7+ messages in thread
From: Borek Lupoměský @ 2001-01-16 15:17 UTC (permalink / raw)
To: pgsql-sql@postgresql.org
On Mon, 15 Jan 2001, Mauricio Hipp Werner wrote:
MHW> in oracle the is used (+)
MHW> in sybase the is used * and
MHW> in postgreSql?
In PostgreSQL we have no outer joins at all. But it is promised they
are going to arrive soon, perhaps in 7.1?
Bye Borek
--
=====================================================================
BOREK LUPOMESKY Usti nad Labem, Czech Republic, Europe
WWW: http://www.volny.cz/borekl/ PGP keyid: B6A06AEB
==========[ MIME/ISO-8859-2 & PGP encrypted mail welcome ]===========
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: outer join in PostgreSql
@ 2001-01-16 16:44 Hannu Krosing <hannu@tm.ee>
parent: Thomas Lockhart <lockhart@alumni.caltech.edu>
0 siblings, 1 reply; 7+ messages in thread
From: Hannu Krosing @ 2001-01-16 16:44 UTC (permalink / raw)
To: Mauricio Hipp Werner <mhipp@mail.pjud.cl>; +Cc: Thomas Lockhart <lockhart@alumni.caltech.edu>; Alexaki Sofia <alexaki@ics.forth.gr>; pgsql-sql@postgresql.org, Markus Wagner <wagner@imsd.uni-mainz.de>; pgsql-interfaces
Thomas Lockhart wrote:
>
> 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?
>
> The PostgreSQL outer join is accomplished using SQL92 syntax. You will
> not find real outer joins *except* in the current beta release, and
> beware that there may be some tweaks to the grammar to help with
> conformance to the standard.
>
> In any case, check the standard or try something like "select * from t1
> left outer join t2 on (i)".
To get a feel you could use MS Access visual query builder and then view
the source.
I have not checked it lately, but it very likely produces SQL92
compliant outer joins.
-----------
Hannu
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: outer join in PostgreSql
@ 2001-01-17 17:14 Ross J. Reedstrom <reedstrm@rice.edu>
parent: Hannu Krosing <hannu@tm.ee>
0 siblings, 0 replies; 7+ messages in thread
From: Ross J. Reedstrom @ 2001-01-17 17:14 UTC (permalink / raw)
To: pgsql-sql@postgresql.org; pgsql-interfaces
On Tue, Jan 16, 2001 at 06:44:18PM +0200, Hannu Krosing wrote:
>
> To get a feel you could use MS Access visual query builder and then view
> the source.
> I have not checked it lately, but it very likely produces SQL92
> compliant outer joins.
>
I fired up MS-Access 97SR1, just to see, and here's one result:
SELECT Institution.InstitutionName, InstituteAssignment.PersonID FROM
Institution LEFT JOIN InstituteAssignment ON Institution.InstID =
InstituteAssignment.InstID;
I'm surprised: looks pretty standard, to me.
Ross
--
Open source code is like a natural resource, it's the result of providing
food and sunshine to programmers, and then staying out of their way.
[...] [It] is not going away because it has utility for both the developers
and users independent of economic motivations. Jim Flynn, Sunnyvale, Calif.
^ permalink raw reply [nested|flat] 7+ messages in thread
end of thread, other threads:[~2001-01-17 17:14 UTC | newest]
Thread overview: 7+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2001-01-15 22:16 outer join in PostgreSql Mauricio Hipp Werner <mhipp@mail.pjud.cl>
2001-01-15 21:36 ` Patrick Welche <prlw1@newn.cam.ac.uk>
2001-01-15 22:21 ` Peter Eisentraut <peter_e@gmx.net>
2001-01-16 05:12 ` Thomas Lockhart <lockhart@alumni.caltech.edu>
2001-01-16 16:44 ` Hannu Krosing <hannu@tm.ee>
2001-01-17 17:14 ` Ross J. Reedstrom <reedstrm@rice.edu>
2001-01-16 15:17 ` Borek Lupoměský <borekl@volny.cz>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox