Re: [BUGS] Bug #851: cast() no longer works in array inserts

2002-12-18 Thread Tom Lane
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

Re: [BUGS] Bug #851: cast() no longer works in array inserts

2002-12-18 Thread Tom Lane
[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

[BUGS] Bug #851: cast() no longer works in array inserts

2002-12-18 Thread pgsql-bugs
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