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

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