Home > mailing lists

Changing a column constraint? - Mailing list pgsql-sql

From	Henry Holland
Subject	Changing a column constraint?
Date	February 21, 2002 18:20:33
Msg-id	Pine.LNX.4.44.0202201019430.1326-100000@st12.stats.ru.ac.za Whole thread Raw
List	pgsql-sql

Tree view

Hi,

If I have a column constraint:addr_type char( 10 ) default 'street'CHECK( addr_type = 'street' || addr_type = 'pobox'
),
in a table, how can I add another choice to the list after I've already
entered data into the table?

Henry

pgsql-sql by date:

From: "Andy Marden"
Date: 21 February 2002, 18:15:12
Subject: Dates and year 2000

From: Richard Emberson
Date: 21 February 2002, 18:28:34
Subject: Matching columns in rows from two tables

Changing a column constraint? - Mailing list pgsql-sql

Previous

Next