date array

From: "A(dot) R(dot) Van Hook" <hook(at)lake-lotawana(dot)mo(dot)us>
To: pgsql-sql(at)postgresql(dot)org
Subject: date array
Date: 2006-04-23 12:55:54
Message-ID: 444B795A.5090304@lake-lotawana.mo.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)lake-lotawana(dot)mo(dot)us

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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Wiebe Cazemier 2006-04-23 15:27:58 Re: Primary key reference count
Previous Message Ben K. 2006-04-22 21:37:07 Re: find all tables with a specific column name?