Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
Thread:
Lists: pgsql-bugspgsql-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

pgsql-hackers by date

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

pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group