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

Поиск
Список
Период
Сортировка
От avpro avpro
Тема how to add 'time with time zone' data types and 'interval' data types
Дата
Msg-id CAAQdDnkJTUNhyj4GQAgPW6u7H6MCPHEQTR_FfJxZG2rESTdOBA@mail.gmail.com
обсуждение исходный текст
Ответы Re: how to add 'time with time zone' data types and 'interval' data types  (Andreas Kretschmer <akretschmer@spamfence.net>)
Список 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 по дате отправления:

Предыдущее
От: Magnus Persson
Дата:
Сообщение: Re: Returning NULL from SRF
Следующее
От: Andreas Kretschmer
Дата:
Сообщение: Re: how to add 'time with time zone' data types and 'interval' data types