Re: Problem with BETWEEN and a view.

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Andrew Snow <als(at)fl(dot)net(dot)au>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: Problem with BETWEEN and a view.
Date: 2000-11-15 06:07:06
Message-ID: 12316.974268426@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-hackers

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

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Andrew Snow 2000-11-15 06:35:45 Re: Problem with BETWEEN and a view.
Previous Message Andrew McMillan 2000-11-15 06:06:00 Re: NT Binary V7.0 - postgres fails start cause PG_VERSION

Browse pgsql-hackers by date

  From Date Subject
Next Message Andrew Snow 2000-11-15 06:35:45 Re: Problem with BETWEEN and a view.
Previous Message Alfred Perlstein 2000-11-15 06:02:52 Re: One more 486 Optimizations...