Hi all,
I have a table that contains an array as one of its fields. When I'm
returning some results from the database (including that particular
field), the array is returned as a String. The thing is: I need an
array of Strings, not just one String.
My question: can PostgreSQL return an array of Strings or can it only
return a string. If it can only return one String, what would be the
best way to parse it in order to get the separate elements of the
array?
I hope I'm missing something simple here :o
Thans for your time,
Frederik
Roedy Green - 30 May 2004 23:58 GMT
>My question: can PostgreSQL return an array of Strings or can it only
>return a string. If it can only return one String, what would be the
>best way to parse it in order to get the separate elements of the
>array?
for a list of the data types it supports, including arrays, see
http://mindprod.com/jgloss/postgresql.html

Signature
Canadian Mind Products, Roedy Green.
Coaching, problem solving, economical contract programming.
See http://mindprod.com/jgloss/jgloss.html for The Java Glossary.