Howto convert arrays 2 query results

From: Jeroen Schaap <jeroen(at)rulffh(dot)medfac(dot)leidenuniv(dot)nl>
To: pgsql-general(at)postgreSQL(dot)org
Subject: Howto convert arrays 2 query results
Date: 1999-06-09 07:13:05
Message-ID: XFMail.990609091305.jeroen@rulffh.medfac.leidenuniv.nl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Herouth Maoz 1999-06-09 15:05:44 Re: [GENERAL] Howto convert arrays 2 query results
Previous Message Oleg Broytmann 1999-06-09 06:53:45 Re: [GENERAL] Compiling libpq