Re: BETWEEN [SYMMETRIC | ASYMMETRIC]

"Robert B. Easter" <reaster(at)comptechnews(dot)com> writes:
> subselects=# SELECT 2 BETWEEN 3 AND 1;
> ?column?
> ----------
> f
> (1 row)

SQL92 quoth:

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

so this is correct behavior, even if it might seem surprising.

> Any chance of BETWEEN [SYMMETRIC | ASYMMETRIC] being implemented?

> SELECT 2 BETWEEN SYMMETRIC 3 AND 1;
> ?column?
> ----------
> t
> (1 row)

Build a function based on this idea:

regression-# select case
regression-# when 3 < 1 then 2 between 3 and 1
regression-# else 2 between 1 and 3
regression-# end;
case
------
t
(1 row)

I don't really see this as important enough to justify introducing a
nonstandard syntax for it...

regards, tom lane