arrays - Mailing list pgsql-sql

From Marcin Mazurek - Multinet SA - Poznan
Subject arrays
Date
Msg-id Pine.BSF.3.96.991201232906.28778H-100000@arka
Whole thread Raw
In response to Partial Search  (pez@aiming.net)
Responses Re: [SQL] arrays  (Karel Zak - Zakkr <zakkr@zf.jcu.cz>)
Re: [SQL] arrays  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-sql
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




pgsql-sql by date:

Previous
From: Satyajeet Seth
Date:
Subject: Except operation
Next
From: Karel Zak - Zakkr
Date:
Subject: Re: [SQL] arrays