Re: patch (for 9.1) string functions
От | Pavel Stehule |
---|---|
Тема | Re: patch (for 9.1) string functions |
Дата | |
Msg-id | AANLkTinxKRgg68HK3Hpa0z7o7P95ywXVVvgvCr6Fer74@mail.gmail.com обсуждение исходный текст |
Ответ на | Re: patch (for 9.1) string functions (Robert Haas <robertmhaas@gmail.com>) |
Список | 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 по дате отправления: