Thanks, that does the trick and makes perfect sense. (I was eventually able to find a couple of threads on the same topic in this group). Less embarrassing since this is the 'novice' section!
- Leon
On Aug 5, 2010, at 9:20 AM, Tom Lane wrote:
> Leon Starr <leon_starr(at)modelint(dot)com> writes:
>> BAD (attributes concatenated) why?
>> contracts=# select getContracts();
>> getcontracts
>> -----------------
>> (1,USGE,Renew)
>> (2,USGE,Renew)
>> (3,USGE,Renew)
>
> This is expected. Try doing this if you want to "explode" the
> sub-columns:
>
> select * from getContracts();
>
> regards, tom lane