Postgres Pro
Downloads
Home   >   mailing lists

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

From Armand Turpel
Subject one null value in array isnt allowed???
Date
Msg-id 4BB081B9.1000603@mnhn.lu
Whole thread Raw
Responses Re: one null value in array isnt allowed???  ("Wappler, Robert" <rwappler@ophardt.com>)
List pgsql-general
Tree view 
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.
#####################################################################################

pgsql-general by date:

Previous
From: Ognjen Blagojevic
Date:
Subject: Re: need a query
Next
From: "Wappler, Robert"
Date:
Subject: Re: one null value in array isnt allowed???