Howto convert arrays 2 query results - Mailing list pgsql-general

From Jeroen Schaap
Subject Howto convert arrays 2 query results
Date
Msg-id XFMail.990609091305.jeroen@rulffh.medfac.leidenuniv.nl
Whole thread Raw
Responses Re: [GENERAL] Howto convert arrays 2 query results  (Herouth Maoz <herouth@oumail.openu.ac.il>)
List pgsql-general
Dear psql'ers,

Do you know of any way to generally convert arrays into query results?

I know it is better to implement arrays as tables, but that results in
unreadable tables (with 10 rows with id=1, 15 with id=2, 2 with id=3 ad
infundum...).

So is there any way to convert an array into a table? Should I
write a function or a C-function?

Thanks a lot,

Jeroen

---
Jeroen Schaap.............I was dreaming of guitarnotes that would irritate
Homepage: <http://rulffh.medfac.leidenuniv.nl>..| ^|^ |...an executive kind
Keywords: Guitars, Linux, Mac and SCN...........\_`-'_/..............of guy
Tel: (0)71-5276811................................| |...........Frank Zappa

pgsql-general by date:

Previous
From: Oleg Broytmann
Date:
Subject: Re: [GENERAL] Compiling libpq
Next
From: Herouth Maoz
Date:
Subject: Re: [GENERAL] Howto convert arrays 2 query results