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???
Date: Wed, 21 Sep 2005 21:15:12 -0600
Message-ID: <20050922031511.GB90260@winnie.fuhr.org> (raw)
In-Reply-To: <20050922015636.72033.qmail@web35205.mail.mud.yahoo.com>
References: <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
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: mike@fuhr.org, survivedsushi@yahoo.com
Subject: Re: delete item[5] from varchar[] array???
In-Reply-To: <20050922031511.GB90260@winnie.fuhr.org>
* 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