display array field as row

From: hendra kusuma <penguinroad(at)gmail(dot)com>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: display array field as row
Date: 2009-02-03 04:12:18
Message-ID: 26dadb3d0902022012v671d9708m1e0db84f4ff1588@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Dear all,

Does anyone know how to display an array data into row?
for exampla, I have data like this

conname contype conkey

kelas_pkey p {1,2}

kelas_tahun f {2}

And I want to to display those data above like below

kelas_pkey p 1
kelas_pkey p 2
kelas_tahun f 2

Do you know any sql syntax that would do?
I cannot find it in documentation
or is it not possible?

Regards
Hendra

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Phoenix Kiula 2009-02-03 04:21:06 Re: Smartest way to resize a column?
Previous Message rhubbell 2009-02-03 03:46:32 Re: calculating elapsed times between timestamps