Re: Trouble accessing %ROWTYPE attributes returned by function

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