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]

Reply via email to