|
1 | 1 | <!--
|
2 |
| -$Header: /cvsroot/pgsql/doc/src/sgml/ref/alter_domain.sgml,v 1.5 2002/12/0605:07:16 momjian Exp $ |
| 2 | +$Header: /cvsroot/pgsql/doc/src/sgml/ref/alter_domain.sgml,v 1.6 2002/12/0616:40:13 momjian Exp $ |
3 | 3 | PostgreSQL documentation
|
4 | 4 | -->
|
5 | 5 |
|
@@ -192,25 +192,25 @@ ALTER DOMAIN <replaceable class="PARAMETER">domain</replaceable>
|
192 | 192 | Usage
|
193 | 193 | </title>
|
194 | 194 | <para>
|
195 |
| - To add a NOT NULL constraint to acolumn: |
| 195 | + To add a NOT NULL constraint to adomain: |
196 | 196 | <programlisting>
|
197 | 197 | ALTER DOMAIN zipcode SET NOT NULL;
|
198 | 198 | </programlisting>
|
199 |
| - To remove a NOT NULL constraint from acolumn: |
| 199 | + To remove a NOT NULL constraint from adomain: |
200 | 200 | <programlisting>
|
201 | 201 | ALTER DOMAIN zipcode DROP NOT NULL;
|
202 | 202 | </programlisting>
|
203 | 203 | </para>
|
204 | 204 |
|
205 | 205 | <para>
|
206 |
| - To add a check constraint to atable: |
| 206 | + To add a check constraint to adomain: |
207 | 207 | <programlisting>
|
208 | 208 | ALTER DOMAIN zipcode ADD CONSTRAINT zipchk CHECK (char_length(VALUE) = 5);
|
209 | 209 | </programlisting>
|
210 | 210 | </para>
|
211 | 211 |
|
212 | 212 | <para>
|
213 |
| - To remove a check constraint from atable and all its children: |
| 213 | + To remove a check constraint from adomain: |
214 | 214 | <programlisting>
|
215 | 215 | ALTER DOMAIN zipcode DROP CONSTRAINT zipchk;
|
216 | 216 | </programlisting>
|
|