Date: Sat, 4 Dec 1999 03:23:30 +0100 (CET)
From: Peter Eisentraut <peter_e@gmx.net>
To: Marcin Mazurek - Multinet SA - Poznan <m.mazurek@multinet.pl>
cc: pgsql-sql@postgresql.org
Subject: Re: [SQL] arrays
In-Reply-To: <Pine.BSF.3.96.991201232906.28778H-100000@arka>
Message-ID: <Pine.LNX.4.20.9912021935560.384-100000@localhost.localdomain>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=ISO-8859-1
Content-Transfer-Encoding: 8BIT
Sender: Peter Eisentraut <peter@hub.org>

Don't use arrays. They look very promising but they aren't. Most of these
kind of questions can be resolved by designing a proper relational
database schema.

On 1999-12-01, Marcin Mazurek - Multinet SA - Poznan mentioned:

> Hi,
> I have a table: orders (id int, val INT4[][]);. The question is how to
> select in separate rows values from particular id?
> 
> example:
> insert into orders values(1,'{{1,1},{1,4},{2,3}}');
> select val from orders where id=1; gives me:
> val
> -------------------
> {{1,2},{1,4},{2,3}}
> 
> How can I make from it to columned table with first and second int
> separated?
> 
> mazek
> 
> 
> 
> ************
> 
> 

-- 
Peter Eisentraut                  Sernanders väg 10:115
peter_e@gmx.net                   75262 Uppsala
http://yi.org/peter-e/            Sweden