Skip site navigation (1) Skip section navigation (2)

Re: Trouble accessing %ROWTYPE attributes returned by function

From: Leon Starr <leon_starr(at)modelint(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: Trouble accessing %ROWTYPE attributes returned by function
Date: 2010-08-05 16:54:49
Message-ID: 168BF459-B851-4F23-94AB-7790EB324F9E@modelint.com (view raw or flat)
Thread:
Lists: pgsql-novice
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



In response to

pgsql-novice by date

Next:From: Mladen GogalaDate: 2010-08-05 22:44:22
Subject: Schemas in a database?
Previous:From: Tom LaneDate: 2010-08-05 16:31:35
Subject: Re: Looking for SKYLINE command

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group