diff options
| author | Vadim B. Mikheev <vadim4o@yahoo.com> | 1997-10-02 02:50:22 +0000 |
|---|---|---|
| committer | Vadim B. Mikheev <vadim4o@yahoo.com> | 1997-10-02 02:50:22 +0000 |
| commit | 61a72beda5e625a9073b5f6c3b5122fd76bcda03 (patch) | |
| tree | 33c5c6272a29532210078ac002efd3d8621a9a50 | |
| parent | 127f21c788bf77ea23a17872c7281ed241f8fc38 (diff) | |
| download | postgresql-61a72beda5e625a9073b5f6c3b5122fd76bcda03.tar.gz postgresql-61a72beda5e625a9073b5f6c3b5122fd76bcda03.zip | |
A word about constraint nature of DEFAULT.
| -rw-r--r-- | src/man/create_table.l | 6 |
1 files changed, 4 insertions, 2 deletions
diff --git a/src/man/create_table.l b/src/man/create_table.l index a4658627729..2d20ef14280 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 |