Cast timestamptz to/from integer?

Поиск
Список
Период
Сортировка
От Chris Angelico
Тема Cast timestamptz to/from integer?
Дата
Msg-id CAPTjJmr7dwfp-+5=yaULEBV5irjSmz86+FZT7qBLQ+ygRneg2Q@mail.gmail.com
обсуждение исходный текст
Ответы Re: Cast timestamptz to/from integer?
Список pgsql-general
I work a lot with Unix times as integers, but would like to store them
in Postgres as 'timestamp(0) with time zone' for convenience and
readability. Unfortunately the syntax to translate between the two is
a little cumbersome, so I'm looking at hiding it away behind a
function - or a cast. However, the CREATE CAST docs say that I have to
be the owner of either the source or target types, which presumably
means I can't define a cast from timestamptz to int.

Is there a workaround for this?

Chris Angelico

В списке pgsql-general по дате отправления:

Предыдущее
От: Greg Smith
Дата:
Сообщение: Re: oracle linux
Следующее
От: Bartosz Dmytrak
Дата:
Сообщение: Re: Please help me to take a look of the erros in my functions. Thanks.