Re: patch (for 9.1) string functions - Mailing list pgsql-hackers

From Pavel Stehule
Subject Re: patch (for 9.1) string functions
Date
Msg-id AANLkTinxKRgg68HK3Hpa0z7o7P95ywXVVvgvCr6Fer74@mail.gmail.com
Whole thread Raw
In response to Re: patch (for 9.1) string functions  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers
2010/7/26 Robert Haas <robertmhaas@gmail.com>:
> On Mon, Jul 26, 2010 at 2:09 PM, Pavel Stehule <pavel.stehule@gmail.com> wrote:
>> I understand, but with only text accepting, then CONCAT will has much
>> less benefit - you can't do a numeric list, for example
>>
>> see concat(c1::text, ',', c2::text, ',' ...)
>>
>> with this is much simpler use a pipes '' || c1 || ',' || c2 ... and
>> this operator does necessary cast self.
>>
>> This function is probably one use case of exception from our rules.
>
> At least two, right?  Because for that use case you'd probably want
> concat_ws().

sorry, yes

Pavel

 In fact, it's hard for me to think of a variadic text
> function where you wouldn't want the "no casts" behavior you're
> getting via ANY.
>
> --
> Robert Haas
> EnterpriseDB: http://www.enterprisedb.com
> The Enterprise Postgres Company
>


pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: patch (for 9.1) string functions
Next
From: Robert Haas
Date:
Subject: Re: do we need to postpone beta4?