Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #5732: parsing of: "WHERE mycol=123AND ..." - Mailing list pgsql-bugs

From Greg Stark
Subject Re: BUG #5732: parsing of: "WHERE mycol=123AND ..."
Date
Msg-id AANLkTi=Edm+PMb=CDZ1Y1r_F_7e7k+HmnpqzzZdRirA7@mail.gmail.com
Whole thread Raw
In response to Re: BUG #5732: parsing of: "WHERE mycol=123AND ..."  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
Tree view 
On Sat, Oct 30, 2010 at 11:23 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>
> Anybody want to try Oracle, DB2, etc?

Oracle seems to behave like us:

SQL> select * from (select 1 as x from dual) where 1=1and x=1;

         X
----------
         1



--
greg

pgsql-bugs by date:

Previous
From: "Henry"
Date:
Subject: BUG #5736: 9.0.1 segmentation fault (sig11) during long-lived update
Next
From: Tom Lane
Date:
Subject: Re: BUG #5736: 9.0.1 segmentation fault (sig11) during long-lived update