Re: BETWEEN patch

From: Thomas Swan <tswan(at)ics(dot)olemiss(dot)edu>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: BETWEEN patch
Date: 2001-01-24 19:23:44
Message-ID: 5.0.2.1.0.20010124132253.02f1aea0@tangent.ics.olemiss.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

At 1/24/2001 10:19 AM, Tom Lane wrote:
>Thomas Swan <tswan(at)ics(dot)olemiss(dot)edu> writes:
> > A patch to gram.y in src/backend/parser
> > Provides for the SQL99 expected behavior of
> > select * from foo where fo_num between 1 and 5
> > yields the same result as
> > select * from foo where fo_num between 5 and 1
>
>This is NOT correct under either SQL92 or SQL99. Read the spec again.
>
> regards, tom lane

After sending it... I realized that it was not correct either. So, I'm
back to figuring how to do it... so, um, ignore the previous patch...

Thanks..

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Stephan Szabo 2001-01-24 19:25:35 Re: [GENERAL] child table doesn't inherit PRIMARY KEY?
Previous Message Mikheev, Vadim 2001-01-24 19:23:25 RE: WAL documentation