Re: CREATE TYPE and %ROWTYPE - Mailing list pgsql-novice

From Steve Tucknott
Subject Re: CREATE TYPE and %ROWTYPE
Date
Msg-id 1112943112.1232.6.camel@retsol1
Whole thread Raw
In response to CREATE TYPE and %ROWTYPE  (Steve Tucknott <steve@retsol.co.uk>)
Responses Re: CREATE TYPE and %ROWTYPE
List pgsql-novice
Before I go too far, has anyone got any ideas on this?

On Sun, 2005-04-03 at 14:18, Steve Tucknott wrote:
> (Sorry if this appears twice - I sent the previous mail as the wrong
> mail ID)
>
> PostgreSQL 7.4.5
>
> Is there a way of using %ROWTYPE in custom types?
> I want to return two/three complete record areas to a calling 4gl
> program.
> I can define a custom type, ie:
> CREATE TYPE myTest AS (
> fld1      INTEGER,
> fld2      VARCHAR,
> fld3       .......etc
> );
> This works fine. But if I define:
> CREATE TYPE myTest AS (
> area1              tableName1%ROWTYPE,
> area2              tableName2%ROWTYPE
> );
> I get an error. This then means that I have to define myTest with the
> individual fields (which I can do) - but which in turn means that if the
> tables change, I have to remember to change the procs.
>
>
>
> Regards,
>
> Steve Tucknott
>
> ReTSol Ltd
>
> DDI: 01903 828769
>
--


Regards,

Steve Tucknott
ReTSol Ltd

DDI    01903 828769
MOBILE    07736715772



pgsql-novice by date:

Previous
From: Tom Lane
Date:
Subject: Re: Getting running totals
Next
From: Tom Lane
Date:
Subject: Re: CREATE TYPE and %ROWTYPE