On Jul 27, 2009, at 6:52 PM, Michael Glaesemann wrote:
>
> On Jul 27, 2009, at 10:54 , Alexey Klyukin wrote:
>
>> Hello,
>>
>> I was looking for a way to get the difference (interval) between 2
>> timetz values, i.e.:
>
> I don't have a solution, but am curious what your use case is for
> timetz (as opposed to timestamptz).
I'm writing a custom trigger function that has to compare values of
time* types and make some actions depending on a result.
Answering my own question, Alvaro proposed a solution with
extract(epoch from tz_value), the result is in seconds:
postgres=# select extract(epoch from '00:00:00+0'::timetz) -
extract(epoch from '2:00:00+2'::timetz);
?column?
----------
0
(1 row)
--
Alexey Klyukin http://www.CommandPrompt.com
The PostgreSQL Company - Command Prompt, Inc.