On Sat, Apr 02, 2005 at 12:29:15PM +1200, Zitan Broth wrote: > > Basically I am selecting out "one row" from the database with multiple > columns (should have told you that earlier) so it seems that unfortunately > your elegant approach below might not work. Although some of the columns > are text and some numeric I was planning to load them all into strings. > Perhaps I could convert the output to strings on the fly or something?
What are you trying to do? That is, what's the ultimate purpose of building the array? It might be easier to make suggestions if we knew the "what" rather than focusing on a particular "how." -- Michael Fuhr http://www.fuhr.org/~mfuhr/ ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq