Martin Marques <martin(at)marquesminen(dot)com(dot)ar> writes:
> Rodrigo De Len escribi:
>> "In any case, the longest possible character string that can be stored
>> is about 1 GB."
>>
> I was asking about the limit in the argument. Is it the same as the
> limits the types have in table definition?
Yeah, ultimately this is a palloc() restriction on the size of any one
data value.
> I have always heard that modification queries should be EXECUTED in PL.
> AFAICR.
Run far away from whatever source gave you that advice...
regards, tom lane