Received: from frithjof.reiner (a108.dialin.tuwien.ac.at [192.35.240.118]) by mail.postgresql.org (8.11.1/8.11.1) with SMTP id eBVLeCL03400 for ; Sun, 31 Dec 2000 16:40:13 -0500 (EST) (envelope-from areiner@tph.tuwien.ac.at) Received: (qmail 270 invoked by uid 500); 31 Dec 2000 21:29:33 -0000 From: "Albert REINER" Date: Sun, 31 Dec 2000 22:29:33 +0100 To: PostgreSQL-SQL Subject: Arrays Message-ID: <20001231222933.A227@frithjof> Mail-Followup-To: PostgreSQL-SQL Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.2.5i X-Archive-Number: 200012/320 X-Sequence-Number: 660 Saluton, I somehow get the impressions that support for arrays is not a high priority with PostgreSQL, even though I think it would be very handy. On the other hand, the system itself uses arrays e.g. for user groups, so I guess there should be readily available functions/operators for dealing with that, but I cannot seem to be able to find them. Is there a simple way of checking whether e.g. a given int4 is in a given int4-array? Is there a way to "thread" a command over an array? By this I mean: Given an array {1, 2, 3} and a table t like id | name --------|-------- 1 | joe 2 | fred 3 | mark , a call to select thread('||', t, {1,2,3}) should produce 'joefredmark'. Thanks in advance, Albert. -- -------------------------------------------------------------------------- Albert Reiner Deutsch * English * Esperanto * Latine --------------------------------------------------------------------------