Re: [SQL] arrays

Поиск
Список
Период
Сортировка
От Bruno Wolff III
Тема Re: [SQL] arrays
Дата
Msg-id 20020930122926.GA5358@wolff.to
обсуждение исходный текст
Ответ на Re: [SQL] CURRENT_TIMESTAMP  (Bruce Momjian <pgman@candle.pha.pa.us>)
Ответы Re: [SQL] arrays  (Achilleus Mantzios <achill@matrix.gatewaynet.com>)
Re: [SQL] arrays  (Mike Sosteric <mikes@athabascau.ca>)
Список 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 по дате отправления:

Предыдущее
От: Jochem van Dieten
Дата:
Сообщение: Re: [JDBC] Prepared statement performance...
Следующее
От: Achilleus Mantzios
Дата:
Сообщение: Re: [SQL] arrays