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... -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
