Re: delete item[5] from varchar[] array??? - Mailing list pgsql-sql

From Matthew Peter
Subject Re: delete item[5] from varchar[] array???
Date
Msg-id 20050924025153.62888.qmail@web35205.mail.mud.yahoo.com
Whole thread Raw
In response to Re: delete item[5] from varchar[] array???  (Michael Fuhr <mike@fuhr.org>)
List pgsql-sql
--- 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 


pgsql-sql by date:

Previous
From: Axel Rau
Date:
Subject: Re: Updating cidr column with network operator
Next
From: "Ilya A. Kovalenko"
Date:
Subject: VACUUM FULL vs dump & restore