Postgres Pro
Downloads
Home   >   mailing lists

Re: Use of reference table ('look-up-table') and FK constraint - Mailing list pgsql-sql

From Charles Hauser
Subject Re: Use of reference table ('look-up-table') and FK constraint
Date
Msg-id 1034863604.1760.15.camel@pandorina.biology.duke.edu
Whole thread Raw
In response to Re: Use of reference table ('look-up-table') and FK constraint  (Josh Berkus <josh@agliodbs.com>)
Responses Re: Use of reference table ('look-up-table') and FK constraint
List pgsql-sql
Tree view 
Josh & Stephan,

This helps a lot - thanks!

Any idea what datatype 'Identifier_type IDENTITY' specifies?  I don't
see this in the postgres documentation.  I'll see what I can find in
sybase lingo.


CREATE TABLE phone (        phone_id             Identifier_type IDENTITY,        phone_number         varchar(20) NOT
NULL,       community_id         numeric(12) NOT NULL,        type                 varchar(10) NULL REFERENCES
 
phone_types(type) ON 
DELETE SET NULL );

regards,

Charles

pgsql-sql by date:

Previous
From: "Gaetano Mendola"
Date:
Subject: Re: functions that return a dataset or set of rows
Next
From: Charles Hauser
Date:
Subject: object oriented vs relational DB