Malcolm Tredinnick <[EMAIL PROTECTED]> writes:
> So given that one cannot just insert 0 into a bigint field (even an
> array of bigints), since postgres complains it is not of the correct
> type, how is one supposed to fille a field of bigint[] with {0, 0}?
I must be missing something ... what is
[EMAIL PROTECTED] writes:
> cast() no longer works in array inserts
It never has. You are confusing a rather lame failure of error checking
in 7.1 with a feature. 7.1 and before will in fact take quite a lot of
random garbage in array input strings :=(
regards, tom lane
Malcolm Tredinnick ([EMAIL PROTECTED]) reports a bug with a severity of 2
The lower the number the more severe it is.
Short Description
cast() no longer works in array inserts
Long Description
If I have a table containing an array (e.g. a bigint[] field), then it does not appear
to be possible t