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
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
