> > 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,
Pennsylvania19026