Re: POSIX-style regular expressions - Mailing list pgsql-sql

On Tue, 10 Sep 2002, Goran Buzic wrote:

> 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}$'),

Bad column type choice.  char(6) is space padded, so 1.2. looks like
"1.2.  ".  For me, 12.12. works, but any shorter one fails.  Unless
you need space padding elsewhere, you may just want to use varchar(6);