From: Achilleus Mantzios <achill@matrix.gatewaynet.com>
To: Bruno Wolff III <bruno@wolff.to>
Cc: Mike Sosteric <mikes@athabascau.ca>
Cc: pgsql-general@postgresql.org
Cc: pgsql-sql@postgresql.org
Subject: Re: [SQL] arrays
Date: Mon, 30 Sep 2002 16:18:54 +0300 (EEST)
Message-ID: <Pine.LNX.4.44.0209301613230.32609-100000@matrix.gatewaynet.com> (raw)
In-Reply-To: <20020930122926.GA5358@wolff.to>
On Mon, 30 Sep 2002, Bruno Wolff III wrote:
>
> It is unusual to want to store arrays in a database. Normally you want to
> use additional tables instead. For example multilanguage titles is something
> I would expect to be in a table that had a column referencing back to
> another table defining the object a title was for, a column with the
> title and a column with the language.
I think arrays are one of the cool features of postgres
(along with gist indexes).
Here are some common uses:
- Tree representation (the genealogical from child to ancestors approach)
- Storing of polynomial formulae of arbitary degree
checkout the intarray package in contrib for further info.
I think pgsql arrays provide a natural solution to certain problems
where it fits.
==================================================================
Achilleus Mantzios
S/W Engineer
IT dept
Dynacom Tankers Mngmt
Nikis 4, Glyfada
Athens 16610
Greece
tel: +30-10-8981112
fax: +30-10-8981877
email: achill@matrix.gatewaynet.com
mantzios@softlab.ece.ntua.gr
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: achill@matrix.gatewaynet.com, bruno@wolff.to, mikes@athabascau.ca, pgsql-general@postgresql.org
Subject: Re: [SQL] arrays
In-Reply-To: <Pine.LNX.4.44.0209301613230.32609-100000@matrix.gatewaynet.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