Re: [BUGS] Problem with BETWEEN and a view.

2000-11-14 Thread Tom Lane
Andrew Snow <[EMAIL PROTECTED]> writes: > Here's a simpler script which reproduces the bug: OK, I can reproduce the bug in 7.0.2 and 7.0.3, but not in current development sources. More tomorrow ... I'm about out of steam for tonight ... regards, tom lane

Re: [BUGS] Problem with BETWEEN and a view.

2000-11-14 Thread Andrew Snow
> 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 ;-) Well

Re: [BUGS] Problem with BETWEEN and a view.

2000-11-14 Thread Tom Lane
Andrew Snow <[EMAIL PROTECTED]> 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 t

Re: [BUGS] Problem with BETWEEN and a view.

2000-11-14 Thread Andrew Snow
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 st

[BUGS] Problem with BETWEEN and a view.

2000-11-14 Thread Andrew Snow
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 --++