On Wed, 2010-02-10 at 03:46 +0000, Iain Barnett wrote:
> 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.
What about:
CREATE TYPE inventory_item2 AS (
ii inventory_item,
size integer
);
or:
CREATE TABLE inventory_item2 (
LIKE inventory_item,
size integer
);
and that will automatically create the type.
Regards,
Jeff Davis