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=LH5rvJU7QOfH/5s/cXflzv6IM5pSFaGx7vGAEOiN1BhTGIgyX7QKmhSUIuE+amA2CBA7N+pZVsZ/wwIYLKwqnEJFxzpe/1aQLkvhic3K2tdBKz0NJYNc/8/pg5lPDDjKeNB8g5TjbT7xWt7b6g0UEcx8WbILX4xxy6CRaHEMeXw=
	;
Message-ID: <20050924025153.62888.qmail@web35205.mail.mud.yahoo.com>
Date: Fri, 23 Sep 2005 19:51:53 -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: <20050923191057.GA81954@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 Fri, Sep 23, 2005 at 10:02:44AM -0700, Matthew
> Peter wrote:
> > --- Michael Fuhr <mike@fuhr.org> wrote:
> > > test=> UPDATE foo SET a = a[1:3] || a[5:6];
> >
> > I sure hope there is a better way :) There must be
> an
> > easy, native way to interface with arrays.
> 
> Hoping a thing is true doesn't mean it must be true
> :-)
> 
> > We all know programming languages have ways to
> delete items in an
> > array natively, it just needs to be exposed.
> 
> No, we don't all know that because it isn't
> generally true, or else
> you're using a loose definition of "natively." 
> Languages differ
> in what capabilities they offer "natively."
> 
> contrib/intarray implements an intarray_del_elem()
> function,
> presumably because the core product doesn't offer
> that capability,
> or at least didn't when the module was written.  If
> you think it's
> there just waiting to be exposed, then dig into the
> source code and
> expose it :-)
> 
> -- 
> Michael Fuhr
> 

Yes. I should've said "most" and some thanks to libs.
I'm busy in other source which is why I hoped those
who were already engulfed in pg's source would have a
solution... Thought this functionality may be
around... somewhere.... which is why I asked. 

Took a brief look at intarray_del_elem() function you
mentioned. This may be perfect, and then some. I'll
play around with it. Thanks 

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