Re: Use of reference table ('look-up-table') and FK constraint

From: Charles Hauser <chauser(at)duke(dot)edu>
To: josh(at)agliodbs(dot)com
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Use of reference table ('look-up-table') and FK constraint
Date: 2002-10-17 14:06:44
Message-ID: 1034863604.1760.15.camel@pandorina.biology.duke.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Charles Hauser 2002-10-17 14:27:11 object oriented vs relational DB
Previous Message Gaetano Mendola 2002-10-17 12:58:53 Re: functions that return a dataset or set of rows