how to add 'time with time zone' data types and 'interval' data types - Mailing list pgsql-novice

From avpro avpro
Subject how to add 'time with time zone' data types and 'interval' data types
Date
Msg-id CAAQdDnkJTUNhyj4GQAgPW6u7H6MCPHEQTR_FfJxZG2rESTdOBA@mail.gmail.com
Whole thread Raw
Responses Re: how to add 'time with time zone' data types and 'interval' data types  (Andreas Kretschmer <akretschmer@spamfence.net>)
List pgsql-novice
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;
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;

thanks for your hint,
John.

pgsql-novice by date:

Previous
From: Magnus Persson
Date:
Subject: Re: Returning NULL from SRF
Next
From: Andreas Kretschmer
Date:
Subject: Re: how to add 'time with time zone' data types and 'interval' data types