I applied the attached patch to HEAD. concat(), concat_ws(), left(), right(), and reverse() are in it, but format() and sprintf() are not. It's my understanding that we don't have consensus about the best syntax for the formatting function. We can forget about RAISE. C-like printf syntax is the next candidate, but we should consider about other ones restarting with a clean slate.
Anyway, the newly added functions are useful for developers especially migrated from other database products. Thank you. On Mon, Aug 23, 2010 at 11:41 PM, Pavel Stehule <pavel.steh...@gmail.com> wrote: > 2010/8/23 Tom Lane <t...@sss.pgh.pa.us>: >> You should leave RAISE alone and just think about printf. > > ok - then we don't need modify proposed patch. "Format" function is > enough for PL/pgSQL and other PL languages has own mutation of this > functions. There are not barrier for implementation as custom > function, so we can hold this function most simple. -- Itagaki Takahiro
stringfunc-20100824.diff
Description: Binary data
-- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers