Re: BUG #5732: parsing of: "WHERE mycol=123AND ..."

From: Greg Stark <gsstark(at)mit(dot)edu>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Jeff Davis <pgsql(at)j-davis(dot)com>, Josh Kupershmidt <schmiddy(at)gmail(dot)com>, pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #5732: parsing of: "WHERE mycol=123AND ..."
Date: 2010-10-30 19:19:31
Message-ID: AANLkTi=Edm+PMb=CDZ1Y1r_F_7e7k+HmnpqzzZdRirA7@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Sat, Oct 30, 2010 at 11:23 AM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2010-10-30 20:43:01 Re: BUG #5736: 9.0.1 segmentation fault (sig11) during long-lived update
Previous Message Henry 2010-10-30 19:18:59 BUG #5736: 9.0.1 segmentation fault (sig11) during long-lived update