Re: Trouble accessing %ROWTYPE attributes returned by function - Mailing list pgsql-novice

Thanks, that does the trick and makes perfect sense.  (I was eventually able to find a couple of threads on the same
topicin 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@modelint.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