While I do understand that the BETWEEN operator is actually "synctactic 
sugar", from time to time I find myself wondering about a better BETWEEN for
DATEs, TIMEs and TIMESTAMPs (but not only these ones).

Infact I always have managed ranges where the lower part is to be matched with
the ">=" comparison operator while the higher part is matched with the "<".
In other words, until now I've always encountered intervals of the
type "[...)" and not "[...]".

Wouldn't it be nice to have a version of the BETWEEN operator which uses
such a kind of intervals?


-- 
Fahrbahn ist ein graues Band
weisse Streifen, grĂ¼ner Rand

-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply via email to