Re: Unixtime (epoch) into timestamp?

Ericson Smith <eric(at)did-it(dot)com> writes:
> Just added this handy little function to our catalog based on that
> answer:

> CREATE FUNCTION "fn_date"(int4) RETURNS timestamp with time zone AS
> 'DECLARE
> my_epoch ALIAS FOR $1;
> my_ret timestamp;
> BEGIN
> SELECT INTO my_ret "timestamp"(my_epoch);
> RETURN my_ret;
> END;' LANGUAGE 'plpgsql';

Better make that
SELECT INTO my_ret "timestamptz"(my_epoch);
else it will break in 7.3 --- "timestamp" is going to start meaning
"timestamp without time zone", per SQL spec. Likewise my_ret had
better be explicitly declared timestamptz or timestamp with time zone.
Otherwise looks good.

regards, tom lane