Re: Problem with BETWEEN and a view.

Andrew Snow <als(at)fl(dot)net(dot)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