On Sat, Feb 13, 2010 at 7:24 PM, Jeff Davis wrote:
> On Wed, 2010-02-10 at 03:46 +, Iain Barnett wrote:
>
>> CREATE TYPE inventory_item2 AS (
>> name text,
>> supplier_id integer,
>> price numeric,
>> size integer
>> );
>>
>>
>> but it would be handy if I
On Wed, 2010-02-10 at 03:46 +, Iain Barnett wrote:
> CREATE TYPE inventory_item2 AS (
> nametext,
> supplier_id integer,
> price numeric,
> size integer
> );
>
>
> but it would be handy if I could reuse inventory_item instead of
> having to retype the w
Hi,
Is there a way to create a new composite type using already existing composite
type?
For example,
CREATE TABLE inventory_item (
nametext,
supplier_id integer REFERENCES suppliers,
price numeric CHECK (price > 0)
);
produces the following type automatic
