Re: [GENERAL] Re: BETWEEN clause

2001-04-24 Thread Paul Tomblin
Quoting will trillich ([EMAIL PROTECTED]): > > 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 Burt

Re: [GENERAL] Re: BETWEEN clause

2001-04-24 Thread will trillich
On Tue, Apr 24, 2001 at 12:07:41AM -0400, Joel Burton wrote: > 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 BETWE