one null value in array isnt allowed???

[Armand Turpel <aturpel@xxxxxxx>]

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

--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general