Message-ID: <444D36FE.2010909@lake-lotawana.mo.us>
Date: Mon, 24 Apr 2006 15:37:18 -0500
From: "A. R. Van Hook" <hook@lake-lotawana.mo.us>
User-Agent: Mozilla Thunderbird 1.0 (X11/20041206)
MIME-Version: 1.0
To: Bruno Wolff III <bruno@wolff.to>
CC: pgsql-sql@postgresql.org
Subject: Re: date array
References: <444B795A.5090304@lake-lotawana.mo.us>
	<20060423163624.GA15802@wolff.to>
	<444BC5BD.6020705@lake-lotawana.mo.us>
	<20060424033749.GA17134@wolff.to>
In-Reply-To: <20060424033749.GA17134@wolff.to>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

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