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
