From: Bruno Wolff III <bruno@wolff.to>
To: Mike Sosteric <mikes@athabascau.ca>
Cc: pgsql-general@postgresql.org
Cc: pgsql-sql@postgresql.org
Subject: Re: [SQL] arrays
Date: Mon, 30 Sep 2002 07:29:26 -0500
Message-ID: <20020930122926.GA5358@wolff.to> (raw)
In-Reply-To: <Pine.SUN.3.96.1020929180740.10131E-100000@aupair.cs.athabascau.ca>
References: <200209292127.g8TLRw219816@candle.pha.pa.us>
<Pine.SUN.3.96.1020929180740.10131E-100000@aupair.cs.athabascau.ca>
On Sun, Sep 29, 2002 at 18:12:55 -0600,
Mike Sosteric <mikes@athabascau.ca> wrote:
> On Sun, 29 Sep 2002, Bruce Momjian wrote:
>
> 3) can you do selects on only a portion of a multidimensional array. That
> is, if you were storing multilanguage titles in a two dimensional array,
>
> [en], "english title"
> [fr], "french title"
>
> could you select where title[0] = 'en'
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.
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: bruno@wolff.to, mikes@athabascau.ca, pgsql-general@postgresql.org
Subject: Re: [SQL] arrays
In-Reply-To: <20020930122926.GA5358@wolff.to>
* 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