Skip site navigation (1) Skip section navigation (2)

Re: BETWEEN patch

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Thomas Swan <tswan(at)ics(dot)olemiss(dot)edu>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: BETWEEN patch
Date: 2001-01-26 04:15:09
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-hackers
Thomas Swan <tswan(at)ics(dot)olemiss(dot)edu> writes:
> 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.

> 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...

Someone (Easter, IIRC) already submitted a patch to support the SQL99
SYMMETRIC BETWEEN option.  I think we're sitting on it till 7.2, on the
grounds of "no new features in beta".  Check the list archives for the
last few weeks if you need it now.

			regards, tom lane

In response to

pgsql-hackers by date

Next:From: Hiroshi InoueDate: 2001-01-26 04:18:15
Subject: Re: Open 7.1 items
Previous:From: Hiroshi InoueDate: 2001-01-26 04:09:11
Subject: Re: Open 7.1 items

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group