X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id A471111F6B6F for ; Sun, 23 Apr 2006 13:18:29 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 55333-01 for ; Sun, 23 Apr 2006 13:18:18 -0300 (ADT) X-Greylist: delayed 00:05:01.083431 by SQLgrey- Received: from rwcrmhc11.comcast.net (rwcrmhc11.comcast.net [204.127.192.81]) by postgresql.org (Postfix) with ESMTP id 56A9A11F7B45 for ; Sun, 23 Apr 2006 10:01:08 -0300 (ADT) Received: from [192.168.1.2] (c-69-242-185-103.hsd1.mo.comcast.net[69.242.185.103]) by comcast.net (rwcrmhc11) with ESMTP id <20060423125556m11005bri5e>; Sun, 23 Apr 2006 12:56:06 +0000 Message-ID: <444B795A.5090304@lake-lotawana.mo.us> Date: Sun, 23 Apr 2006 07:55:54 -0500 From: "A. R. Van Hook" User-Agent: Mozilla Thunderbird 1.0 (X11/20041206) X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: date array Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200604/154 X-Sequence-Number: 24963 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