[GENERAL] CREATE TABLE ... CONSTRAINT

Now, the second syntax is standard SQL and the parser should recognize it, but in any case at least pg_dump compliance should be aimed at. Bye Dario -- ###### # Dario Besseghini, system manager, # Depart

Re: [GENERAL] CREATE TABLE ... CONSTRAINT

> > Ciao Dario, > > Seems that your syntax (CREATE TABLE test (number int4) CONSTRAINT > test_number CHECK number > 3;) > isn't SQL standard. > > --- > There are two kinds of Integrity CONSTRAINTs; > - the Column constraint: > CREATE TABLE test ( number int check