Re: string function - "format" function proposal

Tom Lane <tgl@sss.pgh.pa.us>

From: Tom Lane <tgl@sss.pgh.pa.us>
To: Pavel Stehule <pavel.stehule@gmail.com>
Cc: Itagaki Takahiro <itagaki.takahiro@gmail.com>, Alvaro Herrera <alvherre@commandprompt.com>, PostgreSQL Hackers <pgsql-hackers@postgresql.org>
Date: 2010-09-06T13:47:55Z
Lists: pgsql-hackers
Pavel Stehule <pavel.stehule@gmail.com> writes:
> 2010/9/6 Itagaki Takahiro <itagaki.takahiro@gmail.com>:
>> Which should we use for such purposes? Consistent behavior is
>> obviously preferred. Boolean type might be the only type that
>> is converted to different representation in typoutput or cast-to-test,
>> but we should consider to have boolean-specific hardwired code,
>> or cast all types to text instead of output functions.

> Personally I prefer casting to text -

No, you need to use the I/O functions.  Not every type is guaranteed to
have a cast to text.

> iit allows some later
> customizations. And it's more consistent with || operator.

I don't buy either of those arguments.

			regards, tom lane