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

Re: Outer join differences

From: "Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)au>
To: "Stephan Szabo" <sszabo(at)megazone23(dot)bigpanda(dot)com>,"Yuva Chandolu" <ychandolu(at)ebates(dot)com>
Cc: <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Outer join differences
Date: 2002-07-31 04:35:13
Message-ID: GNELIHDDFBOCMGBFGEFOIEGPCDAA.chriskl@familyhealth.com.au (view raw or flat)
Thread:
Lists: pgsql-hackers
> > When I run the query "select yt1_name, yt1_descr, yt2_name,
> yt2_descr from
> > yuva_test1 left outer join yuva_test2 on yt1_id=yt2_id and yt2_name =
> > '2-name2'" on postgres database I get the following results

Probaly if you change your postgres query to this, it will give the same
answer as Oracle:

select yt1_name, yt1_descr, yt2_name,
yt2_descr from
yuva_test1 left outer join yuva_test2 on yt1_id=yt2_id where yt2_name =
'2-name2';

??

Chris


> > But when I tried the same on Oracle(8.1.7) (the query is
> "select yt1_name,
> > yt1_descr, yt2_name, yt2_descr from yuva_test1, yuva_test2 where
> > yt1_id=yt2_id(+) and yt2_name = '2-name2'') I get the following result

And maybe if you change the oracle query to this, it will give the same
answer as postgres:

select yt1_name,
yt1_descr, yt2_name, yt2_descr from yuva_test1, yuva_test2 where
yt1_id=yt2_id(+) and yt2_name = '2-name2'(+);

Just guessing tho.

Chris


In response to

pgsql-hackers by date

Next:From: Bruce MomjianDate: 2002-07-31 04:35:28
Subject: Re: Open 7.3 items
Previous:From: Stephan SzaboDate: 2002-07-31 04:31:26
Subject: Re: Outer join differences

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