Date: Wed, 21 Sep 2005 21:15:12 -0600
From: Michael Fuhr <mike@fuhr.org>
To: Matthew Peter <survivedsushi@yahoo.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: delete item[5] from varchar[] array???
Message-ID: <20050922031511.GB90260@winnie.fuhr.org>
References: <20050922015636.72033.qmail@web35205.mail.mud.yahoo.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <20050922015636.72033.qmail@web35205.mail.mud.yahoo.com>

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