From: | Joel Burton <jburton(at)scw(dot)org> |
---|---|
To: | Paul Tomblin <ptomblin(at)xcski(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org, pgsql-novice(at)postgresql(dot)org |
Subject: | Re: BETWEEN clause |
Date: | 2001-04-24 04:07:41 |
Message-ID: | Pine.LNX.4.21.0104240005450.4921-100000@olympus.scw.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-novice |
On Mon, 23 Apr 2001, Paul Tomblin wrote:
> Is the "BETWEEN" clause inclusive or exclusive? ie if I say "WHERE
> latitude BETWEEN 45 and 55", will I get examples where the latitude equals
> 45 or not? Also, is "latitude BETWEEN 45 and 55" any more efficient than
> "latitude >= 45 AND latitude <= 55", or is it just a stylistic thing?
yes, yes, and no:
select 'exclusive' where 2 between 1 and 3;
?column?
----------
inclusive
test=# select 'inclusive' where 1 between 1 and 3;
?column?
----------
inclusive
test=# create view its_really_the_same_thing as select true where 1
between 1 and 3;
test=# \d its_really_the_same_thing
...
View definition: SELECT 't'::bool WHERE ((1 >= 1) AND (1 <= 3));
HTH,
--
Joel Burton <jburton(at)scw(dot)org>
Director of Information Systems, Support Center of Washington
From | Date | Subject | |
---|---|---|---|
Next Message | eric07 | 2001-04-24 05:11:55 | configure on a P4? |
Previous Message | Paul Tomblin | 2001-04-24 02:54:05 | BETWEEN clause |
From | Date | Subject | |
---|---|---|---|
Next Message | will trillich | 2001-04-24 07:08:50 | Re: Re: BETWEEN clause |
Previous Message | Paul Tomblin | 2001-04-24 02:54:05 | BETWEEN clause |