strftime

[Egor Shipovalov]

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?

Best regards,
Egor Shipovalov.
---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

[Mike Mascari]

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/s...ormatting.html

Hope that helps,

Mike Mascari
ma*****@mascari.com

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html