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 01EDA11F6202 for ; Sun, 23 Apr 2006 13:33:56 -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 57104-03 for ; Sun, 23 Apr 2006 13:33:33 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from wolff.to (wolff.to [66.93.197.194]) by postgresql.org (Postfix) with SMTP id 89D6111F620C for ; Sun, 23 Apr 2006 13:33:30 -0300 (ADT) Received: (qmail 16217 invoked by uid 500); 23 Apr 2006 16:36:24 -0000 Date: Sun, 23 Apr 2006 11:36:24 -0500 From: Bruno Wolff III To: "A. R. Van Hook" Cc: pgsql-sql@postgresql.org Subject: Re: date array Message-ID: <20060423163624.GA15802@wolff.to> Mail-Followup-To: Bruno Wolff III , "A. R. Van Hook" , pgsql-sql@postgresql.org References: <444B795A.5090304@lake-lotawana.mo.us> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <444B795A.5090304@lake-lotawana.mo.us> User-Agent: Mutt/1.4.2.1i X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200604/155 X-Sequence-Number: 24964 On Sun, Apr 23, 2006 at 07:55:54 -0500, "A. R. Van Hook" wrote: > How do you add null values to a date array? > > update dattable set insDate= '{04/12/2006,null}' <-- doesn't work That is the correct format. However, I think that only works in HEAD (what will become 8.2 in about 6 months).