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

Re: outer join in PostgreSql

From: "Ross J(dot) Reedstrom" <reedstrm(at)rice(dot)edu>
To: pgsql-sql(at)postgresql(dot)org, pgsql-interfaces(at)postgresql(dot)org
Subject: Re: outer join in PostgreSql
Date: 2001-01-17 17:14:26
Message-ID: 20010117111426.A21852@rice.edu (view raw or flat)
Thread:
Lists: pgsql-interfacespgsql-sql
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.


In response to

pgsql-interfaces by date

Next:From: David ZollDate: 2001-01-17 18:17:57
Subject: Re: How do I install PostgreSQL ODBC Drivers for Windows from Source?
Previous:From: Cedar CoxDate: 2001-01-17 16:53:18
Subject: triggered data change violation

pgsql-sql by date

Next:From: Ligia M. PimentelDate: 2001-01-17 17:14:56
Subject: ltsWriteBlock: failed to write block XX of temporary file. Perharps out of disk space...
Previous:From: Josh BerkusDate: 2001-01-17 16:53:00
Subject: Re: Yet one more question

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