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...