Re: [HACKERS] help bug and comment char.
Bruce Momjian <maillist@candle.pha.pa.us>
From: Bruce Momjian <maillist@candle.pha.pa.us>
To: lockhart@alumni.caltech.edu (Thomas G. Lockhart)
Cc: terry@terrym.com, hackers@postgreSQL.org
Date: 1999-02-02T18:42:10Z
Lists: pgsql-hackers
> > In looking for how to do table constraints psql help says: > > software=> \h create table > > Command: create table > > Description: create a new table > > Syntax: > > CREATE TABLE class_name > > (attr1 type1 [DEFAULT expression] [NOT NULL], ...attrN) > > [INHERITS (class_name1, ...class_nameN) > > [[CONSTRAINT name] CHECK condition1, ...conditionN]] > > This syntax help is out of date. The syntax for v6.4 (and perhaps > v6.3.2) became compatible with SQL92, except of course for the INHERITS > clause. That still must appear outside of the column-definition parens. Fixed. -- Bruce Momjian | http://www.op.net/~candle maillist@candle.pha.pa.us | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania 19026