avpro avpro <avprowebeden@gmail.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°