diff options
Diffstat (limited to 'src')
| -rw-r--r-- | src/man/create_table.l | 9 | ||||
| -rw-r--r-- | src/man/pgbuiltin.3 | 8 |
2 files changed, 9 insertions, 8 deletions
diff --git a/src/man/create_table.l b/src/man/create_table.l index bd2a87170b8..a4658627729 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.8 1997/09/27 03:58:29 momjian Exp $ +.\" $Header: /cvsroot/pgsql/src/man/Attic/create_table.l,v 1.9 1997/10/01 17:05:13 thomas 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 [\fBdefault\fP value] - [\fB,\fP attname type [\fBdefault\fP value] ]\fB )\fP +\fBcreate table\fR classname \fB(\fPattname type [not null] [\fBdefault\fP value] + [\fB,\fP attname type [\fBnot null\fP] [\fBdefault\fP value] ]\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] @@ -25,7 +25,8 @@ and the attributes are as specified in the list of Each attribute is created with the type specified by .IR type "." Each type may be a simple type, a complex type (set) or an array type. -Each attribute may have a default value, specified by the +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. .PP diff --git a/src/man/pgbuiltin.3 b/src/man/pgbuiltin.3 index 1cc2f3857b1..51355ef16a3 100644 --- a/src/man/pgbuiltin.3 +++ b/src/man/pgbuiltin.3 @@ -1,6 +1,6 @@ .\" This is -*-nroff-*- .\" XXX standard disclaimer belongs here.... -.\" $Header: /cvsroot/pgsql/src/man/Attic/pgbuiltin.3,v 1.5 1997/09/27 04:37:33 thomas Exp $ +.\" $Header: /cvsroot/pgsql/src/man/Attic/pgbuiltin.3,v 1.6 1997/10/01 17:05:16 thomas Exp $ .TH PGBUILTIN INTRO 04/01/97 PostgreSQL PostgreSQL .SH "DESCRIPTION" This section describes the data types, functions and operators @@ -592,9 +592,9 @@ functions, arguments can be `year', `month', `day', `hour', `minute', and `second', as well as the more specialized quantities `decade', `century', `millenium', `millisecond', and `microsecond'. -date_part() also allows -`dow' -to return day of week and `epoch' to return seconds since 1970. +date_part() allows `dow' +to return day of week and `epoch' to return seconds since 1970 for datetime +and 'epoch' to return total elapsed seconds for timespan. .nf Functions: |