v7.0.2: can't use 'EXTRACT(EPOCH FROM'

Поиск
Список
Период
Сортировка
От Trevin Chow
Тема v7.0.2: can't use 'EXTRACT(EPOCH FROM'
Дата
Msg-id 20010731002256.H15708-100000@benny.geektank.org
обсуждение исходный текст
Ответы Re: v7.0.2: can't use 'EXTRACT(EPOCH FROM'  (Peter Eisentraut <peter_e@gmx.net>)
Список pgsql-bugs
I'm running postgres 7.0.3 on one machine and 7.1.2 on another.  I tried
running the exact SQL sample from the user manual for date time
functions:

SELECT EXTRACT(EPOCH FROM TIMESTAMP '2001-02-16 20:38:40');

This example won't run on the v7.0.3 and I get teh following error:

ERROR:  parser: parse error at or near "epoch"

However, the same SQL sample runs on v7.1.2.  Am I doing something wrong
here? Is this a known bug?

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Odpověď: Re: backend don't use index whenquerying by indexed column
Следующее
От: Wolfgang Winkler
Дата:
Сообщение: locale and german umlauts