Changing a column constraint?

From: Henry Holland <hjholland(at)gmx(dot)net>
To: pgsql sql-list <pgsql-sql(at)postgresql(dot)org>
Subject: Changing a column constraint?
Date: 2002-02-20 13:21:16
Message-ID: Pine.LNX.4.44.0202201019430.1326-100000@st12.stats.ru.ac.za
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

Browse pgsql-sql by date

  From Date Subject
Next Message Peter Eisentraut 2002-02-20 16:19:28 Re: combination of 'textcat' and 'interval' in 7.2.
Previous Message Thomas Good 2002-02-20 13:11:11 Re: Issues w/ 7.1 to 7.2 upgrade.