Re: patch (for 9.1) string functions

Pavel Stehule <pavel.stehule@gmail.com>

From: Pavel Stehule <pavel.stehule@gmail.com>

To: Merlin Moncure <mmoncure@gmail.com>

Cc: PostgreSQL Hackers <pgsql-hackers@postgresql.org>

Date: 2010-03-09T18:31:30Z

Lists: pgsql-hackers

2010/3/9 Merlin Moncure <mmoncure@gmail.com>:
> On Tue, Mar 9, 2010 at 9:30 AM, Pavel Stehule <pavel.stehule@gmail.com> wrote:
>> postgres=# select concat('ahaha',10,null,current_date, true);
>>         concat
>> ------------------------
>>  ahaha,10,,2010-03-09,t
>
> why are there commas in the output?
>

I though so comma can be default separator - but I see - it is wrong -
separator have to be empty string.

Pavel


> merlin
>