From: A. R. Van Hook <hook@lake-lotawana.mo.us>
To: Bruno Wolff III <bruno@wolff.to>
Cc: pgsql-sql@postgresql.org
Subject: Re: date array
Date: Mon, 24 Apr 2006 15:37:18 -0500
Message-ID: <444D36FE.2010909@lake-lotawana.mo.us> (raw)
In-Reply-To: <20060424033749.GA17134@wolff.to>
References: <444B795A.5090304@lake-lotawana.mo.us>
<20060423163624.GA15802@wolff.to>
<444BC5BD.6020705@lake-lotawana.mo.us>
<20060424033749.GA17134@wolff.to>
While down loading 8.1.3, I tried the following:
update pf_inspectionsBld set insdate[0] = current_date
update pf_inspectionsBld set insdate[1] = current_date
update pf_inspectionsBld set insdate[2] = current_date
update pf_inspectionsBld set insdate[3] = current_date
update pf_inspectionsBld set insdate[4] = current_date + 1
select * from pf_inspectionsBld
A-2 | 1793 |
[0:4]={04/24/2006,04/24/2006,04/24/2006,04/24/2006,04/25/2006}
yet if I try
update pr_inspectionsbld set inspdate[3] = null
then
select * from pf_inspectionsBld
A-2 | 1793 |
[0:4]={04/24/2006,04/24/2006,04/24/2006,04/24/2006,04/25/2006}
i.e. no error and no change
what am I missing??
thanks
Bruno Wolff III wrote:
>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).
>>>
>>>
>
>---------------------------(end of broadcast)---------------------------
>TIP 3: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faq
>
>
--
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
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: hook@lake-lotawana.mo.us, bruno@wolff.to
Subject: Re: date array
In-Reply-To: <444D36FE.2010909@lake-lotawana.mo.us>
* 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