Thread

Re: [QUESTIONS] timestamp questions

Bruce Momjian <maillist@candle.pha.pa.us> — 1998-02-04T02:36:11Z

> 
> > 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