Received: from arka.poznan.mtl.pl (IDENT:mazek@arka.poznan.mtl.pl
	[195.116.164.132]) by hub.org (8.9.3/8.9.3) with ESMTP id RAA16696
	for <pgsql-sql@postgresql.org>; Wed, 1 Dec 1999 17:34:27 -0500 (EST)
	(envelope-from m.mazurek@multinet.pl)
Received: from localhost (mazek@localhost)
	by arka.poznan.mtl.pl (8.9.2/8.9.2) with SMTP id XAA00618
	for <pgsql-sql@postgresql.org>; Wed, 1 Dec 1999 23:34:02 +0100 (CET)
X-Authentication-Warning: arka.poznan.mtl.pl: mazek owned process doing -bs
Date: Wed, 1 Dec 1999 23:34:02 +0100 (CET)
From: Marcin Mazurek - Multinet SA - Poznan <m.mazurek@multinet.pl>
X-Sender: mazek@arka
To: pgsql-sql@postgresql.org
Subject: arrays
In-Reply-To: <38452BB4.B7F32589@aiming.net>
Message-ID: <Pine.BSF.3.96.991201232906.28778H-100000@arka>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII

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