On Tue, Jun 22, 2010 at 12:26 AM, Tom Lane t...@sss.pgh.pa.us wrote:
George Weaver gwea...@shaw.ca writes:
I have the following (very simplified) scenario:
CREATE DOMAIN orderstatus AS text NOT NULL DEFAULT 'Open';
CREATE TABLE orders ( orderno serial
George Weaver gwea...@shaw.ca writes:
I have the following (very simplified) scenario:
CREATE DOMAIN orderstatus AS text NOT NULL DEFAULT 'Open';
CREATE TABLE orders ( orderno serial
, status orderstatus
,
Hi all,
I have the following (very simplified) scenario:
CREATE DOMAIN orderstatus AS text NOT NULL DEFAULT 'Open';
ALTER DOMAIN orderstatus ADD CONSTRAINT orderstatus_valid
CHECK (VALUE IN ('Open', 'Shipped', Cancelled'));
CREATE TABLE orders ( orderno serial