Ciao Andrea,
mercoledì, 9 settembre 98, you wrote:
AA> I trust this query on postgresql 6.2.x
AA> CREATE TABLE films (
AA> code CHARACTER(5) CONSTRAINT firstkey PRIMARY KEY,
AA> title CHARACTER VARYING(40) NOT NULL,
AA> did DECIMAL(3) NOT NULL,
AA> date_prod DATE,
AA> kind CHAR(10),
AA> len INTERVAL HOUR TO MINUTE );
AA> but I have error near CONSTRAINT.
AA> Maybe this version of postgres can't accept the primary key?
PostgreSQL 6.2 hasn't this feature, you need v-6.3.2.
Best regards,
Jose' mailto:sferac@bo.nettuno.it