Bug #512: outer join bug - Mailing list pgsql-bugs

From pgsql-bugs@postgresql.org
Subject Bug #512: outer join bug
Date
Msg-id 200111090742.fA97g0d41489@postgresql.org
Whole thread Raw
Responses Re: Bug #512: outer join bug
Re: Bug #512: outer join bug
List pgsql-bugs
Hee-Sun, Choi (hurricane_blue@hanmail.net) reports a bug with a severity of 2
The lower the number the more severe it is.

Short Description
outer join bug

Long Description
Hello!

i met a bug when i was using outer join..

see example code..

Sample Code
select * from
(select .. from .. where .. ) aa
left outer join
(select .. from .. where code='abc') bb on aa.id=bb.id
                        -----------

we will meet error if we will try to compare character in where-clause

No file was uploaded with this report

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: Bug in 7.1.3 and 7.2?
Next
From: Victor Marinescu
Date:
Subject: postgresql 7.1 driver