From 61a72beda5e625a9073b5f6c3b5122fd76bcda03 Mon Sep 17 00:00:00 2001
From: "Vadim B. Mikheev" <vadim4o@yahoo.com>
Date: Thu, 2 Oct 1997 02:50:22 +0000
Subject: [PATCH] A word about constraint nature of DEFAULT.

---
 src/man/create_table.l | 6 ++++--
 1 file changed, 4 insertions(+), 2 deletions(-)

diff --git a/src/man/create_table.l b/src/man/create_table.l
index a465862772..2d20ef1428 100644
--- a/src/man/create_table.l
+++ b/src/man/create_table.l
@@ -1,13 +1,13 @@
 .\" This is -*-nroff-*-
 .\" XXX standard disclaimer belongs here....
-.\" $Header: /cvsroot/pgsql/src/man/Attic/create_table.l,v 1.9 1997/10/01 17:05:13 thomas Exp $
+.\" $Header: /cvsroot/pgsql/src/man/Attic/create_table.l,v 1.10 1997/10/02 02:50:22 vadim Exp $
 .TH "CREATE TABLE" SQL 09/25/97 PostgreSQL
 .SH NAME
 create table \(em create a new class
 .SH SYNOPSIS
 .nf
 \fBcreate table\fR classname \fB(\fPattname type [not null] [\fBdefault\fP value]
-	[\fB,\fP attname type [\fBnot null\fP] [\fBdefault\fP value] ]\fB )\fP
+	[\fB,\fP attname type [\fBdefault\fP value] [\fBnot null\fP] ]\fB )\fP
 	[\fBinherits\fR \fB(\fR classname [\fB,\fR classname] \fB)\fR]
 	[\fBconstraint\fR cname \fBcheck\fR \fB(\fR test \fB)\fR [, \fBcheck\fR \fB(\fR test \fB)\fR ] ]
 	[\fBarchive\fR \fB=\fR archive_mode]
@@ -29,6 +29,8 @@ Each attribute may be specified to be non-null and
 each may have a default value, specified by the
 .IR default
 clause which is the keyword "default" followed by a constant or expression.
+\fBNote\fR: DEFAULT in version 6.2 works like constraint - there is no
+way to insert NULL into an attribute having DEFAULT value.
 .PP
 Each array attribute stores arrays that must have the same number of
 dimensions but may have different sizes and array index bounds.  An
-- 
2.11.0