display array field as row
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
Hello
create or replace function unnest(anyarray)
returns setof anyelement as $$
select $1[i] from generate_series(array_lower($1,1),array_upper($1,1)) g(i);
$$ language sql immutable;
select conname, contype, unnest(conkey) from ...
regards
Pavel Stehule
2009/2/3 hendra kusuma <penguinroad@gmail.com>:
Show quoted text
Dear all,
Does anyone know how to display an array data into row?
for exampla, I have data like thisconname 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 2Do you know any sql syntax that would do?
I cannot find it in documentation
or is it not possible?Regards
Hendra