Re: Cast timestamptz to/from integer?

I think You can use epoch
there is an example:
http://www.postgresql.org/docs/9.1/static/functions-datetime.html

SELECT TIMESTAMP WITH TIME ZONE 'epoch' + 982384720.12 * INTERVAL '1 second';

Regards,
Bartek

2012/4/3 Chris Angelico <rosuav(at)gmail(dot)com>

> 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
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>