Skip site navigation (1) Skip section navigation (2)

Arrays

From: "Albert REINER" <areiner(at)tph(dot)tuwien(dot)ac(dot)at>
To: PostgreSQL-SQL <pgsql-sql(at)postgreSQL(dot)org>
Subject: Arrays
Date: 2000-12-31 21:29:33
Message-ID: 20001231222933.A227@frithjof (view raw or flat)
Thread:
Lists: pgsql-sql
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(at)tph(dot)tuwien(dot)ac(dot)at>
Deutsch       *       English       *       Esperanto       *       Latine
--------------------------------------------------------------------------

Responses

  • Re: Arrays at 2000-12-31 22:28:20 from Oleg Bartunov

pgsql-sql by date

Next:From: Oleg BartunovDate: 2000-12-31 22:28:20
Subject: Re: Arrays
Previous:From: Tom LaneDate: 2000-12-31 17:17:19
Subject: Re: Unable to identify an ordering operator

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group