Re: CONCAT function

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Vinayak <vinpokale(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: CONCAT function
Date: 2014-09-06 17:59:26
Message-ID: 3361.1410026366@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Vinayak <vinpokale(at)gmail(dot)com> writes:
> The pg_catalog.concat() is defined as STABLE function.
> why was STABLE preferred for concat() over IMMUTABLE?

concat() invokes datatype output functions, which are not necessarily
immutable. An easy example is that timestamptz_out's results depend
on the TimeZone setting.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2014-09-06 18:43:56 Re: psql and tab-delimited output
Previous Message Abelard Hoffman 2014-09-06 17:34:01 Re: psql and tab-delimited output