Yuva,
The results make sense to me. The left outer join functionality in Postgres
is explained as follows:
LEFT OUTER JOIN returns all rows in the qualified Cartesian product (i.e.,
all combined rows that pass its ON condition), plus one copy of each row in
the left-hand table for which there wa
> > Here are the details.
>
> Those probably aren't the same outer join queries.
I think you're right, these aren't the same, see below:
>
> > 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
> > =
> This is great, we thought we may go for code changes, we will go with this
> solution instead.
But you did catch Stephan's point that an outer join is not required to
produce the result you apparently want? The equivalent inner join will
be at worst just as fast, and possibly faster, both for P
This is great, we thought we may go for code changes, we will go with this
solution instead.
Thanks
Yuva
-Original Message-
From: Stephan Szabo [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 30, 2002 9:31 PM
To: Yuva Chandolu
Cc: '[EMAIL PROTECTED]'
Subject: Re: [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
answe
On Tue, 30 Jul 2002, Yuva Chandolu wrote:
> Hi,
>
> I see different results in Oracle and postgres for same outer join queries.
> Here are the details.
Those probably aren't the same outer join queries.
> When I run the query "select yt1_name, yt1_descr, yt2_name, yt2_descr from
> yuva_test1 l
-Original Message-
From: Tom Lane [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 30, 2002 9:15 PM
To: Yuva Chandolu
Cc: '[EMAIL PROTECTED]'
Subject: Re: [HACKERS] Outer join differences
Yuva Chandolu <[EMAIL PROTECTED]> writes:
> I see different results in Oracle and postgres
Yuva Chandolu <[EMAIL PROTECTED]> writes:
> I see different results in Oracle and postgres for same outer join queries.
I believe you are sending your bug report to the wrong database.
> When I run the query "select yt1_name, yt1_descr, yt2_name, yt2_descr from
> yuva_test1 left outer join yuva_
Hi,
I see different results in Oracle and postgres for same outer join queries.
Here are the details.
I have the following tables in our pg db
table: yuva_test1
yt1_id yt1_nameyt1_descr
1 1-name1 1-desc1
2 1-name2 1-desc2
3 1-name3 1-de
