From: Bruno Wolff III <bruno@wolff.to>
To: A. R. Van Hook <hook@lake-lotawana.mo.us>
Cc: pgsql-sql@postgresql.org
Subject: Re: date array
Date: Sun, 23 Apr 2006 22:37:49 -0500
Message-ID: <20060424033749.GA17134@wolff.to> (raw)
In-Reply-To: <444BC5BD.6020705@lake-lotawana.mo.us>
References: <444B795A.5090304@lake-lotawana.mo.us>
<20060423163624.GA15802@wolff.to>
<444BC5BD.6020705@lake-lotawana.mo.us>
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" <hook@lake-lotawana.mo.us> 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" <hook@lake-lotawana.mo.us> 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).
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: bruno@wolff.to, hook@lake-lotawana.mo.us
Subject: Re: date array
In-Reply-To: <20060424033749.GA17134@wolff.to>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox