Re: Problem with BETWEEN and a view.

Further to this, I wish you to note the following works correctly:

# select start, stop from mailredirs where start < CURRENT_TIMESTAMP;
start | stop
------------------------+------------------------
2000-10-31 17:26:52+11 | 2000-11-25 16:29:01+11
(1 row)

# select start, stop from mailredirs where stop > CURRENT_TIMESTAMP;
start | stop
------------------------+------------------------
2000-10-31 17:26:52+11 | 2000-11-25 16:29:01+11
(1 row)

Also, there is definitely only one row in the entire "Values" table that
contains a value of "Just because."

# select * from values where value LIKE 'Just because.';
id | attributeid | thingid | value
-------+-------------+---------+---------------
13525 | 46 | 1246 | Just because.
(1 row)

Regards,
Andrew.

On Wed, 15 Nov 2000, I wrote:

>
> I just installed v7.0.3 release on a FreeBSD 4.x system. (Problem still happened in 7.0.2 too).
>
> This is the problem I noticed:
>
> # select * from mailredirs;
> username | destination | start | stop | reason
> ----------+--------------------+------------------------+------------------------+---------------
> als | andrew(at)modulus(dot)org | 2000-10-31 17:26:52+11 | 2000-11-25 16:29:01+11 | Just because.
> (1 row)
>
> # select * from mailredirs where start < CURRENT_TIMESTAMP and stop > CURRENT_TIMESTAMP;
> ERROR: Bad timestamp external representation 'Just because.'
>
> Why is it even looking at the 'reason' field??