Hi
Can anybody help me with POSIX-style regular expression used to check rules
that new data must satisfy for an insert or update operetion.
Table was created as follows.
CREATE TABLE table_name1 ( id1 char(6) NOT NULL CHECK(id1 ~* '^([0-9]{1,2}\.){2}$'), id2 INT NOT NULL,
CONSTRAINTprimary_key PRIMARY KEY (id1, id2), CONSTRAINT id2_exists FOREIGN KEY (id2) REFERENCES
table_name2 ON DELETE CASCADE ON INSERT CASCADE
);
Any id1 that looks like 1.2. 1.12. 12.1. 12.12.
should be inserted into table, but the insert query was rejected with an
error message
ERROR: ExecAppend: rejected due to CHECK constraint table_name1_id1
I tested preceding regular expression with Perl and JavaScript and it worked
fine. Can I use regular expressions with CHECK parametar, and if so, how can
I make it work.
The platform PostgreSQL is installed is Solaris 8 - Intel.