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(at)candle(dot)pha(dot)pa(dot)us