Egor Shipovalov wrote:
> I'm wondering how hard will it be to implement POSIX strftime function and
> what's the best way to go about it? I hooked up similar functions to MySQL
> in the past and all it took was little modification to example C code,
> compiling it as a shared library and issuing one SQL statement. What's the
> PostgreSQL's way to do it?
You can write wrappers for any C function:
http://www.postgresql.org/docs/7.3/static/xfunc-c.html
But PostgreSQL may be able to already to what you want using TO_CHAR():
http://www.postgresql.org/docs/7.3/static/functions-formatting.html
Hope that helps,
Mike Mascari
mascarm@mascari.com