BETWEEN clause - Mailing list pgsql-general

From Paul Tomblin
Subject BETWEEN clause
Date
Msg-id 20010423225405.A9885@allhats.xcski.com
Whole thread Raw
Responses Re: BETWEEN clause
List pgsql-general
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?

--
Paul Tomblin <ptomblin@xcski.com>, not speaking for anybody
There is no substitute for good manners, except, perhaps, fast reflexes.

pgsql-general by date:

Previous
From: newsreader@mediaone.net
Date:
Subject: anyone else with mod_perl/apache and 7.1
Next
From: Joel Burton
Date:
Subject: Re: BETWEEN clause