Problem with extract(epoch from interval ...

Поиск
Список
Период
Сортировка
От Kaloyan Iliev
Тема Problem with extract(epoch from interval ...
Дата
Msg-id 50FFC180.80507@digsys.bg
обсуждение исходный текст
Ответы Re: Problem with extract(epoch from interval ...  (Ian Lawrence Barwick <barwick@gmail.com>)
Список pgsql-sql
Hi,
I have a little problem with extract epoch from interval. It seems that 
the query works if the interval is in a string but not from DB field.
Could someone provide support.
Thanks in advance. Best regards, Kaloyan Iliev

db=# begin;
BEGIN
db=# SELECT version();
version
-------------------------------------------------------------------------------------------------------------
PostgreSQL9.1.6 on amd64-portbld-freebsd9.1, compiled by cc (GCC) 
 
4.2.1 20070831 patched [FreeBSD], 64-bit
(1 row)

db=# SELECT EXTRACT(EPOCH FROM INTERVAL '3 months'); date_part
-----------   7776000
(1 row)

db=# CREATE TABLE a( b interval);
CREATE TABLE
db=# INSERT INTO  a  VALUES ('1 month');
INSERT 0 1
db=# INSERT INTO  a  VALUES ('3 month');
INSERT 0 1
db=#  INSERT INTO  a  VALUES ('6 month');
INSERT 0 1
dbr=#  SELECT extract(EPOCH FROM INTERVAL b) FROM a;
ERROR:  syntax error at or near "b"
LINE 1: SELECT extract(EPOCH FROM INTERVAL b) FROM a;




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

Предыдущее
От: Matthias Nagel
Дата:
Сообщение: Range types (DATERANGE, TSTZRANGE) in a foreign key with "inclusion" logic
Следующее
От: Ian Lawrence Barwick
Дата:
Сообщение: Re: Problem with extract(epoch from interval ...