one null value in array isnt allowed???
Hi,
Updating an array field with one null value isnt possible:
UPDATE table SET integer_array = ARRAY[NULL]
But those queries are working:
UPDATE table SET integer_array = ARRAY[NULL,1]
UPDATE table SET integer_array = ARRAY[1,NULL]
This dosent seems logical to me.
Is it a bug?
Thanks for helping,
atu
#####################################################################################
Scanned by MailMarshal - Marshal's comprehensive email content security solution.
#####################################################################################
On 2010-03-29, Armand Turpel wrote:
Hi,
Updating an array field with one null value isnt possible:
UPDATE table SET integer_array = ARRAY[NULL]
Try to specify an explicit type, e.g. ARRAY[NULL]::int[]
But those queries are working:
UPDATE table SET integer_array = ARRAY[NULL,1]
UPDATE table SET integer_array = ARRAY[1,NULL]This dosent seems logical to me.
Is it a bug?
No, those are obviously arrays of integers inferred from the non-NULL
element.
Thanks for helping,
atu
HTH.
--
Robert...