On Mon, Jul 26, 2010 at 2:09 PM, Pavel Stehule <pavel.steh...@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(). 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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers