Re: one null value in array isnt allowed??? - Mailing list pgsql-general

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