Re: Bug #512: outer join bug

On Fri, 9 Nov 2001 pgsql-bugs(at)postgresql(dot)org wrote:

> Hee-Sun, Choi (hurricane_blue(at)hanmail(dot)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

You're going to need to give a complete bug report with schema and
actual query and what version you're running. I couldn't replicate
what I think you were trying on 7.2b1, but I'm not sure if I'm trying
the same case.