| From: | Paul Tomblin <ptomblin(at)xcski(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | BETWEEN clause |
| Date: | 2001-04-24 02:54:05 |
| Message-ID: | 20010423225405.A9885@allhats.xcski.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-novice |
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(at)xcski(dot)com>, not speaking for anybody
There is no substitute for good manners, except, perhaps, fast reflexes.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Joel Burton | 2001-04-24 04:07:41 | Re: BETWEEN clause |
| Previous Message | Jeff Duffy | 2001-04-24 02:36:03 | Re: installing DBD::Pg without installing postgres |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Joel Burton | 2001-04-24 04:07:41 | Re: BETWEEN clause |
| Previous Message | Joel Burton | 2001-04-24 00:50:06 | Re: Re: CAST doesn't work |