From: GB Clark <postgres@vsservices.com>
To: pgsql-sql@postgresql.org
Subject: Constraint problems
Date: Fri, 27 Sep 2002 13:15:47 -0500
Message-ID: <20020927131547.09ed1af2.postgres@vsservices.com> (raw)
Hello,
I'm trying to create a constraint that will check to see if the inserted data is found
in another column in the table.
It could be that I'm going about this the wrong way, any clues for me?
Here is the present setup data for the table.
--SNIP--
--
--
--
DROP SEQUENCE sysusers_user_id_seq;
CREATE SEQUENCE sysusers_user_id_seq START 1000;
DROP TABLE sysusers;
CREATE TABLE sysusers (
user_id INTEGER DEFAULT nextval('sysusers_user_id_seq')
UNIQUE NOT NULL PRIMARY KEY,
username text NOT NULL UNIQUE,
password text NOT NULL,
createby text NOT NULL DEFAULT 'syscreate',
status char(1) DEFAULT 'A' CHECK (status in ('A', 'I')),
comment1 text,
comment2 text,
tstamp timestamp DEFAULT CURRENT_TIMESTAMP
);
CREATE UNIQUE INDEX username_unique_idx ON sysusers (username);
INSERT INTO sysusers (username, password, createby) VALUES ('syscreate', 'testing', 'syscreate');
ALTER TABLE sysusers ADD CONSTRAINT createby_test CHECK (createby in (username));
INSERT INTO sysusers (username, password) VALUES ('gclarkii', 'testing');
--SNIP--
It is the constraint on createby that I'm trying to get to work.
Thanks for any and all help.
GB
--
GB Clark II | Roaming FreeBSD Admin
gclarkii@VSServices.COM | General Geek
CTHULU for President - Why choose the lesser of two evils?
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: postgres@vsservices.com
Subject: Re: Constraint problems
In-Reply-To: <20020927131547.09ed1af2.postgres@vsservices.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox