Re: [SQL] arrays - Mailing list pgsql-general

From Bruno Wolff III
Subject Re: [SQL] arrays
Date
Msg-id 20020930122926.GA5358@wolff.to
Whole thread Raw
In response to Re: [SQL] CURRENT_TIMESTAMP  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: [SQL] arrays  (Achilleus Mantzios <achill@matrix.gatewaynet.com>)
Re: [SQL] arrays  (Mike Sosteric <mikes@athabascau.ca>)
List pgsql-general
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.

pgsql-general by date:

Previous
From: Jochem van Dieten
Date:
Subject: Re: [JDBC] Prepared statement performance...
Next
From: Achilleus Mantzios
Date:
Subject: Re: [SQL] arrays