DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com;
	h=Message-ID:Received:Date:From:Subject:To:Cc:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding;
	b=4b6LO0l8QUYTJviyvn0K1enAepPnS9srUnwWmSiMCZRS8kgc/XbN19Dr2fGyA7OkibISuWN9CRMiY8Q8czBfQeYW/J6Si+qR9tegD5bXBHhIBblLHarzl2wzS6gCtObn8/L0LpGwJna7vYKjMxXHUGKQ2+naJOpLQYfUzmKfEjQ=
	;
Message-ID: <20050923170244.72178.qmail@web35206.mail.mud.yahoo.com>
Date: Fri, 23 Sep 2005 10:02:44 -0700 (PDT)
From: Matthew Peter <survivedsushi@yahoo.com>
Subject: Re: delete item[5] from varchar[] array???
To: Michael Fuhr <mike@fuhr.org>
Cc: pgsql-sql@postgresql.org
In-Reply-To: <20050922031511.GB90260@winnie.fuhr.org>
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit


--- Michael Fuhr <mike@fuhr.org> wrote:

> On Wed, Sep 21, 2005 at 06:56:36PM -0700, Matthew
> Peter wrote:
> > How is it possible to delete an item from a single
> > dimension varchar[] array? Lets say it has the
> values
> > {1,2,3,4,5,6}... how do i delete at position [4]?
> 
> I'm not sure if there's a better way, but you could
> concatenate the
> slices adjacent to the position you want to delete:
> 
> test=> SELECT a FROM foo;
>        a       
> ---------------
>  {1,2,3,4,5,6}
> (1 row)
> 
> test=> UPDATE foo SET a = a[1:3] || a[5:6];
> UPDATE 1
> test=> SELECT a FROM foo;
>       a      
> -------------
>  {1,2,3,5,6}
> (1 row)
> 
> -- 
> Michael Fuhr
> 


I sure hope there is a better way :) There must be an
easy, native way to interface with arrays. We all know
programming languages have ways to delete items in an
array natively, it just needs to be exposed.


__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com