| 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 |