I have:
CREATE TYPE status AS ('NEW','ACTIVE','DESPATCH','COMPLETE');
and included field in my modified version of dellstore2.sql data
CREATE TABLE pg_orders
(
orderid serial NOT NULL,
customerid integer NOT NULL,
orderdate date NOT NULL,
orderstatus status,
CONSTRAINT pg_orders_pkey PRIMARY KEY (orderid)
)
WITH (OIDS=FALSE)
TABLESPACE datadisk;
Now I have populated table, I have decided I really need a 'CANCEL' status and
append it to emum.list!
Without creating status2 and swapping table fields/data I cannot find an ALTER
TYPE - APPEND TO ENUM command -- would response be different if I wanted to
reorder values?
Regards
Simon Bateman
_________________________________________________________________
View your other email accounts from your Hotmail inbox. Add them now.
http://clk.atdmt.com/UKM/go/167688463/direct/01/
