Changing column constraints?

From: Henry Holland <spoedniek(at)gmx(dot)net>
To: pgsql sql-list <pgsql-sql(at)postgresql(dot)org>
Subject: Changing column constraints?
Date: 2002-02-21 09:25:58
Message-ID: Pine.LNX.4.44.0202211124350.1016-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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Andy Marden 2002-02-21 09:27:31 Re: Dates and year 2000
Previous Message Andy Marden 2002-02-21 07:59:38 Re: Dates and year 2000