Re: Problem with BETWEEN and a view.

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Problem with BETWEEN and a view.
Дата
Msg-id 12316.974268426@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Problem with BETWEEN and a view.  (Andrew Snow <als@fl.net.au>)
Ответы Re: Problem with BETWEEN and a view.  (Andrew Snow <als@fl.net.au>)
Список pgsql-bugs
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

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Andrew Snow
Дата:
Сообщение: Re: Problem with BETWEEN and a view.
Следующее
От: Andrew Snow
Дата:
Сообщение: Re: Problem with BETWEEN and a view.