Re: Problem with BETWEEN and a view.

Andrew Snow <als@fl.net.au> writes:
> # 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??

Looks like a bug to me, but I'd like not to have to reverse-engineer the
test case before I can look at it.  Could you provide some sample data,
as well as the missing "Types" table declaration?  Ideally a psql script
file to load everything up from scratch and trigger the error ;-)

            regards, tom lane