From: | Bruno Wolff III <bruno(at)wolff(dot)to> |
---|---|
To: | Mike Sosteric <mikes(at)athabascau(dot)ca> |
Cc: | pgsql-general(at)postgresql(dot)org, pgsql-sql(at)postgresql(dot)org |
Subject: | Re: [SQL] arrays |
Date: | 2002-09-30 12:29:26 |
Message-ID: | 20020930122926.GA5358@wolff.to |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-hackers pgsql-sql |
On Sun, Sep 29, 2002 at 18:12:55 -0600,
Mike Sosteric <mikes(at)athabascau(dot)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.
From | Date | Subject | |
---|---|---|---|
Next Message | Mike Sosteric | 2002-09-30 12:38:56 | Re: [SQL] arrays |
Previous Message | Jochem van Dieten | 2002-09-30 10:19:41 | Re: [JDBC] Prepared statement performance... |
From | Date | Subject | |
---|---|---|---|
Next Message | Mike Sosteric | 2002-09-30 12:38:56 | Re: [SQL] arrays |
Previous Message | Zeugswetter Andreas SB SD | 2002-09-30 11:59:54 | AIX compilation problems (was Re: Proposal ...) |
From | Date | Subject | |
---|---|---|---|
Next Message | Mike Sosteric | 2002-09-30 12:38:56 | Re: [SQL] arrays |
Previous Message | Tom Lane | 2002-09-30 04:36:34 | Re: [SQL] CURRENT_TIMESTAMP |