From: | Kaloyan Iliev <kaloyan(at)digsys(dot)bg> |
---|---|
To: | pgsql-sql(at)postgresql(dot)org |
Subject: | Problem with extract(epoch from interval ... |
Date: | 2013-01-23 10:54:56 |
Message-ID: | 50FFC180.80507@digsys.bg |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
-------------------------------------------------------------------------------------------------------------
PostgreSQL 9.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;
From | Date | Subject | |
---|---|---|---|
Next Message | Ian Lawrence Barwick | 2013-01-23 11:00:39 | Re: Problem with extract(epoch from interval ... |
Previous Message | Matthias Nagel | 2013-01-23 10:28:10 | Range types (DATERANGE, TSTZRANGE) in a foreign key with "inclusion" logic |