From: Albert REINER <areiner@tph.tuwien.ac.at>
To: PostgreSQL-SQL <pgsql-sql@postgreSQL.org>
Subject: Arrays
Date: Sun, 31 Dec 2000 22:29:33 +0100
Message-ID: <20001231222933.A227@frithjof> (raw)
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 <areiner@tph.tuwien.ac.at>
Deutsch * English * Esperanto * Latine
--------------------------------------------------------------------------
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 using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: areiner@tph.tuwien.ac.at
Subject: Re: Arrays
In-Reply-To: <20001231222933.A227@frithjof>
* 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