Michael Glaesemann <[EMAIL PROTECTED]> writes: > Please find attached two patches (one for pg_proc.h and another for > supporting documentation) for two SQL functions: > epoch_to_timestamp(integer) and epoch_to_timestamptz(double precision), > which convert from UNIX epoch to the native PostgreSQL timestamp and > timestamptz data types. The equivalent SQL code is
Why wouldn't these both take double precision? Actually I think epoch_to_timestamp as such is just plain unnecessary. I'd suggest just one function epoch_to_timestamp that actually yields timestamptz, and then if casting the result to timestamp is needed it'll happen automatically. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]