Message-ID: <50FFC82A.3040305@digsys.bg>
Date: Wed, 23 Jan 2013 13:23:22 +0200
From: Kaloyan Iliev <kaloyan@digsys.bg>
Reply-To: kaloyan@digsys.bg
User-Agent: Mozilla/5.0 (X11; FreeBSD amd64;
	rv:17.0) Gecko/20130114 Thunderbird/17.0.2
MIME-Version: 1.0
CC: pgsql-sql@postgresql.org
Subject: Re: Problem with extract(epoch from interval ...
References: <50FFC180.80507@digsys.bg>
	<CAB8KJ=iKs9A4WHXkUt1PEuuxcj4ajBFr19VR2Ce56wJbKOs2Jw@mail.gmail.com>
In-Reply-To: 
 <CAB8KJ=iKs9A4WHXkUt1PEuuxcj4ajBFr19VR2Ce56wJbKOs2Jw@mail.gmail.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
Precedence: bulk
Sender: pgsql-sql-owner@postgresql.org

Thanks,
It works perfectly.

Regards,
  Kaloyan Iliev
On 23.01.13 13:00, 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;
>
>
> Regards
>
> Ian Barwick


-- 
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql