Re: Problem with extract(epoch from interval ...

Hi

2013/1/23 Kaloyan Iliev <kaloyan(at)digsys(dot)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