Re: Epoch to timestamp conversion function patch

Michael Glaesemann <grzm(at)myrealbox(dot)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