pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
BETWEEN
2+ messages / 2 participants
[nested] [flat]

* BETWEEN
@ 2000-06-16 19:09 Joseph Shraibman <jks@selectacast.net>
  2000-06-20 18:16 ` Re: BETWEEN Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 1 reply; 2+ messages in thread

From: Joseph Shraibman @ 2000-06-16 19:09 UTC (permalink / raw)
  To: pgsql-sql

Why is BETWEEN inclusive?  I had assumed that it was like the english
between, which is exclusive.

playpen=# create table numbs ( a int);
CREATE

playpen=# insert into numbs values(1);
INSERT 35913 1
playpen=# insert into numbs values(2);
INSERT 35914 1
playpen=# insert into numbs values(3);
INSERT 35915 1
playpen=# insert into numbs values(4);
INSERT 35916 1
playpen=# insert into numbs values(5);
INSERT 35917 1
playpen=# insert into numbs values(6);
INSERT 35918 1
playpen=# insert into numbs values(7);
INSERT 35919 1
playpen=# select * from numbs where a between 3 and 6;
 a 
---
 3
 4
 5
 6
(4 rows)



^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: BETWEEN
  2000-06-16 19:09 BETWEEN Joseph Shraibman <jks@selectacast.net>
@ 2000-06-20 18:16 ` Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 0 replies; 2+ messages in thread

From: Tom Lane @ 2000-06-20 18:16 UTC (permalink / raw)
  To: Joseph Shraibman <jks@selectacast.net>; +Cc: pgsql-sql

Joseph Shraibman <jks@selectacast.net> writes:
> Why is BETWEEN inclusive?

Because the SQL92 spec says so:

         6) "X BETWEEN Y AND Z" is equivalent to "X>=Y AND X<=Z".

> I had assumed that it was like the english
> between, which is exclusive.

That's debatable...

			regards, tom lane



^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2000-06-20 18:16 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2000-06-16 19:09 BETWEEN Joseph Shraibman <jks@selectacast.net>
2000-06-20 18:16 ` Tom Lane <tgl@sss.pgh.pa.us>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox