date array - Mailing list pgsql-sql

From A. R. Van Hook
Subject date array
Date
Msg-id 444B795A.5090304@lake-lotawana.mo.us
Whole thread Raw
Responses Re: date array  (Bruno Wolff III <bruno@wolff.to>)
List pgsql-sql
How do you add null values to a date array?

update dattable set insDate = '{04/12/2006,'null'}    <-- doesn't work
update dattable set insDate= '{04/12/2006,null}'     <-- doesn't work
update dattable set insDate= '{04/12/2006,''}'         <-- doesn't work

the table field is defined as insDate date[]




thanks


-- 
Arthur R. Van Hook     Mayor 
The City of Lake Lotawana

hook@lake-lotawana.mo.us

(816) 578-4704 - Home
(816) 578-4215 - City
(816) 564-0769 - Cell



pgsql-sql by date:

Previous
From: Wiebe Cazemier
Date:
Subject: Re: Primary key reference count
Next
From: Bruno Wolff III
Date:
Subject: Re: date array