Re: how to add 'time with time zone' data types and 'interval' data types

avpro avpro <avprowebeden(at)gmail(dot)com> wrote:

> hi all,
>
> 1st scenario: i have a table with two fields both of them ''time with time
> zone'. How could I add them? i would like to have something like: SELECT
> table.field1 + table.field2 as sum;

Add 2 TIME's? Make no sense.

test=*# select '9:00'::time + '12:00'::time;
ERROR: operator is not unique: time without time zone + time without
time zone
LINE 1: select '9:00'::time + '12:00'::time;
^
HINT: Could not choose a best candidate operator. You might need to add
explicit type casts.

What about to add 23:00 and 21:00? 44:00 as TIME?

> 2nd scenario, similar but this time data types are 'interval': i have a table
> with two fields both of them ''interval'. How could I add them? i would like to
> have something like: SELECT table.field1 + table.field2 as sum;

Just do it:

test=*# select '9:00'::interval + '12:00'::interval;
?column?
----------
21:00:00
(1 row)

Andreas
--
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect. (Linus Torvalds)
"If I was god, I would recompile penguin with --enable-fly." (unknown)
Kaufbach, Saxony, Germany, Europe. N 51.05082°, E 13.56889°