Jeff Davis <[EMAIL PROTECTED]> writes:
> I was wondering is there is a good method to make a database field a
> pointer, similar to C. Here is an example I made up of why this could be
> useful:
> Suppose I have a table 'coworkers' with 2 email address fields: work_email
> and home_email. It w
CREATE TABLE coworkers (
id serial PRIMARY KEY,
name varchar(63)
);
CREATE TABLE email_types (
type VARCHAR(10) PRIMARY KEY
);
INSERT INTO email_types VALUES ('home');
INSERT INTO email_types VALUES ('work');
CREATE TABLE emails (
owner INTEGER REFERENCES coworke
