"Bruno BAGUETTE" <pgsql-ml(at)baguette(dot)net> writes:
>> Sooner or later we'll probably invent an explicit function to do this
>> conversion.
> I may be wrong but why create a new fonction for unixtimestamp<-->date
> conversion ?
> I think that the to_date() function is the best place to add this kind
> of conversion.
to_date doesn't seem particularly appropriate. There's no use for a
format string in this context, and there isn't any variant of to_date
that accepts an integer as input anyway.
regards, tom lane