From: Marcin Mazurek - Multinet SA - Poznan <m.mazurek@multinet.pl>
To: pgsql-sql@postgresql.org
Subject: arrays
Date: Wed, 1 Dec 1999 23:34:02 +0100 (CET)
Message-ID: <Pine.BSF.3.96.991201232906.28778H-100000@arka> (raw)
In-Reply-To: <38452BB4.B7F32589@aiming.net>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: m.mazurek@multinet.pl
Subject: Re: arrays
In-Reply-To: <Pine.BSF.3.96.991201232906.28778H-100000@arka>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox