POSIX-style regular expressions

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.