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

From Adrian Klaver
Subject Re: Problem with extract(epoch from interval ...
Date
Msg-id 50FFF595.2070502@gmail.com
Whole thread Raw
In response to Re: Problem with extract(epoch from interval ...  (Ian Lawrence Barwick <barwick@gmail.com>)
List pgsql-sql
On 01/23/2013 03:00 AM, Ian Lawrence Barwick wrote:
> 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;

Would it not be simpler:

test=> SELECT extract(epoch from b) from a; date_part
-----------   2592000   7776000  15552000
(3 rows)

As the b field is already an interval.

>
>
> Regards
>
> Ian Barwick
>
>


-- 
Adrian Klaver
adrian.klaver@gmail.com



pgsql-sql by date:

Previous
From: Andreas
Date:
Subject: Re: Re: [SQL] need some magic with generate_series()
Next
From: Andreas
Date:
Subject: How to access multicolumn function results?