one null value in array isnt allowed???

From: Armand Turpel <aturpel(at)mnhn(dot)lu>
To: <pgsql-general(at)postgresql(dot)org>
Subject: one null value in array isnt allowed???
Date: 2010-03-29 10:32:25
Message-ID: 4BB081B9.1000603@mnhn.lu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Wappler, Robert 2010-03-29 10:58:13 Re: one null value in array isnt allowed???
Previous Message Ognjen Blagojevic 2010-03-29 10:06:14 Re: need a query