Postgres Pro
Downloads
Home   >   mailing lists

how to create a new composite type using already existing composite types - Mailing list pgsql-general

From Iain Barnett
Subject how to create a new composite type using already existing composite types
Date
Msg-id 19EE1475-4329-464C-9781-00AE8C4306AB@gmail.com
Whole thread Raw
Responses Re: how to create a new composite type using already existing composite types
List pgsql-general
Tree view
Hi,

Is there a way to create a new composite type using already existing composite type?

For example,

CREATE TABLE inventory_item (   name            text,   supplier_id     integer REFERENCES suppliers,   price           numeric CHECK (price > 0)
);

produces the following type automatically
CREATE TYPE inventory_item AS (   name            text,   supplier_id     integer,   price           numeric
);

but I'd also like to have a type with an extra column for certain functions

CREATE TYPE inventory_item2 AS (   name            text,   supplier_id     integer,   price           numeric,
size	integer
);

but it would be handy if I could reuse inventory_item instead of having to retype the whole lot. I can't work out or find the right syntax, can anyone show me how? Any help would be much appreciated.

Regards
Iain

pgsql-general by date:

Previous
From: "BillR"
Date:
Subject: Re: R: One column to multiple columns based on constraints?
Next
From: Jayadevan M
Date:
Subject: PostgreSQL - case studies