Thanks I'm having trouble finding any reference to array_out and array_in in the documentation. Is there a way to set a different cast for an array? Regards On 9 December 2011 15:09, Tom Lane <tgl@xxxxxxxxxxxxx> wrote: > Phil Couling <couling@xxxxxxxxx> writes: >> I'm struggling to understand why this casts is not immutable: > >> integer[]::text[] >> text[]::integer[] > > Because it's implemented via array_out/array_in rather than any more > direct method, and those are marked stable because they potentially > invoke non-immutable element I/O functions. > > regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
