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 3285A11F6B2D for ; Mon, 24 Apr 2006 02:39:47 -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 87150-02-2 for ; Mon, 24 Apr 2006 02:39:20 -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 A976411F8D17 for ; Mon, 24 Apr 2006 00:34:51 -0300 (ADT) Received: (qmail 17560 invoked by uid 500); 24 Apr 2006 03:37:49 -0000 Date: Sun, 23 Apr 2006 22:37:49 -0500 From: Bruno Wolff III To: "A. R. Van Hook" Cc: pgsql-sql@postgresql.org Subject: Re: date array Message-ID: <20060424033749.GA17134@wolff.to> Mail-Followup-To: Bruno Wolff III , "A. R. Van Hook" , pgsql-sql@postgresql.org References: <444B795A.5090304@lake-lotawana.mo.us> <20060423163624.GA15802@wolff.to> <444BC5BD.6020705@lake-lotawana.mo.us> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <444BC5BD.6020705@lake-lotawana.mo.us> User-Agent: Mutt/1.4.2.1i X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200604/156 X-Sequence-Number: 24965 Please keep responses copied to the list. This both helps other people with similar questions by getting the discussion in the archives and helps you by letting other people see your additional questions. On Sun, Apr 23, 2006 at 13:21:49 -0500, "A. R. Van Hook" wrote: > I am running 8.1.2, what can I do in the mean time? You could build from source using HEAD. (This is probably not a good idea for a production system.) You could restructure your data model to not use arrays. (You probably shouldn't be using them anyway. Arrays should be used for things that are naturally arrays (e.g. vectors) and I would be surprised if this was the case when you are storing dates.) Also note that 8.1.3 is out and 8.1.4 will probably be out soon, so you should be looking to upgrade in any case. > > > thanks > > Bruno Wolff III wrote: > > >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).