Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 47148475498 for ; Fri, 9 Aug 2002 03:14:16 -0400 (EDT) Received: from ferda.ied.com (xtreme10-98.aci.on.ca [209.50.81.98]) by postgresql.org (Postfix) with ESMTP id 740C247546C for ; Fri, 9 Aug 2002 03:14:05 -0400 (EDT) Received: from [127.0.0.2] (localhost.localdomain [127.0.0.1]) by ferda.ied.com (8.11.6/8.11.6) with ESMTP id g797CNR03550; Fri, 9 Aug 2002 03:12:23 -0400 Date: Fri, 9 Aug 2002 03:12:22 -0400 (EDT) From: h012@ied.com To: Oleg Bartunov , Achilleus Mantzios Cc: pgsql-sql@postgresql.org Subject: Re: expressions operating on arrays In-Reply-To: Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200208/161 X-Sequence-Number: 9007 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/