Re: Epoch to timestamp conversion function patch

Michael Glaesemann <grzm@myrealbox.com> writes:
> Another idea would be to overload TO_TIMESTAMP to take a single double
> precision float parameter rather than two text parameters.

Offhand I'd favor this one.

I think borrowing the function name from MySQL would be asking for
trouble: there's nothing worse than a function that looks compatible
with someone else's but isn't quite.  I don't even understand what
FROM_UNIXTIME(integer, format) is supposed to do --- there are not
multiple formats of Unix timestamps --- so that leads me to be a little
skeptical that their idea of FROM_UNIXTIME(integer) works quite like
ours would, either.  (Plus the integer vs float distinction is not
trivial.)

            regards, tom lane