arrays

From: Marcin Mazurek - Multinet SA - Poznan <m(dot)mazurek(at)multinet(dot)pl>
To: pgsql-sql(at)postgresql(dot)org
Subject: arrays
Date: 1999-12-01 22:34:02
Message-ID: Pine.BSF.3.96.991201232906.28778H-100000@arka
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Karel Zak - Zakkr 1999-12-02 10:20:00 Re: [SQL] arrays
Previous Message Satyajeet Seth 1999-12-01 18:40:13 Except operation