pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: h012@ied.com
To: Oleg Bartunov <oleg@sai.msu.su>
To: Achilleus Mantzios <achill@matrix.gatewaynet.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: expressions operating on arrays
Date: Fri, 9 Aug 2002 03:12:22 -0400 (EDT)
Message-ID: <no.Yo.N.nN.0208090252110.2280-100000@business.com> (raw)
In-Reply-To: <Pine.LNX.4.44.0208090916580.20404-100000@matrix.gatewaynet.com>


 thanks for the pointer, I'm now able to use the operators in expressions!

 w.r.t. modifying the array contents: I looked through 
/usr/lib/pgsql/contrib/intarray/_int.sql.in , but it didn't make me any 
smarter. Are the "..._union" and "..._picksplit" functions supposed to add 
into and remove elements from the arrays ? How would one update a row, 
then, to add an element into one array and remove an element from another?

create table t(id int4[], txt text[]);
update t set id=g_int_union(t.id, '{555}') where t.id *= 444; -- ??
update t set text=g_int_picksplit(t.text, '{"removeme"}') where t.text *= "removeme"; -- ??

 thx,

  John

On Fri, 9 Aug 2002, Oleg Bartunov wrote:

> Look at contrib/intarray. You'll get an index access as a bonus
> 
> 	Oleg

On Fri, 9 Aug 2002, Achilleus Mantzios wrote:

> 
> look at /usr/local/src/postgresql-7.2.1/contrib/intarray
> 
> 

> On Fri, 9 Aug 2002 h012@ied.com wrote:
> 
> >
> >
> >  Hi,
> >
> >   I would like to say:
> >
> > create table test1 (array1 int4[]);
> > insert into test1 values ('{123,234,345}');
> > insert into test1 values ('{456,567,678}');
> >
> >  now what I don't know how to do:
> >
> > -- consider contents of array:
> > select * from test1 where array1 CONTAINS 567;
> >
> > -- APPEND '789' to array in second row:
> > update test1 set array1=(select array1 from test1 where array1 CONTAINS
> > '567' UNION select '789');
> >
> >
> >  How do I go about expressing and operating on the contents of an array ?
> >
> >
> >     Thanks,
> >
> >        John

-- 
-- Gospel of Jesus is the saving power of God for all who believe --
               ## To some, nothing is impossible. ##
                     http://Honza.Vicherek.com/




view thread (7+ messages)  latest in thread

Message-ID: <no.Yo.N.nN.0208090252110.2280-100000@business.com>
Permalink:  ../no.Yo.N.nN.0208090252110.2280-100000@business.com/
Also on:    postgresql.org/message-id/no.Yo.N.nN.0208090252110.2280-100000@business.com

 · 

reply

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 from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-sql@postgresql.org
  Cc: h012@ied.com, oleg@sai.msu.su, achill@matrix.gatewaynet.com
  Subject: Re: expressions operating on arrays
  In-Reply-To: <no.Yo.N.nN.0208090252110.2280-100000@business.com>
  References: <Pine.LNX.4.44.0208090916580.20404-100000@matrix.gatewaynet.com> <no.Yo.N.nN.0208090252110.2280-100000@business.com>

* 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