Re: [QUESTIONS] timestamp questions

There are several things I have attempted to do, that my reference
book says are possible, that do not seem to function. To wit:

wwwlogs=> select * from dates where '1998-01-06 15:59:59' between dt1
and dt2;
WARN:parser: parse error at or near "dt1"

Oh! None of us even thought of writing an expression like that.
Currently, the parser requires that only constants follow BETWEEN.
Bruce, I have a patch which will allow the above expression (column
names in the expression) but I think we will have trouble allowing full
expressions there since the AND looks like a boolean expression. I'll go
ahead and apply my patches soon (tomorrow?) unless you want something
different...

Go head.

--
Bruce Momjian
maillist@candle.pha.pa.us