Re: Problem with extract(epoch from interval ... - Mailing list pgsql-sql

Hi

2013/1/23 Kaloyan Iliev <kaloyan@digsys.bg>:
> 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.
(...)

You have a casting error; instead of:

> 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;

use

SELECT extract(EPOCH FROM b::INTERVAL) FROM a;

or


SELECT extract(EPOCH FROM CAST (b AS INTERVAL)) FROM a;


Regards

Ian Barwick