From: "Goran Buzic" <goran.buzic@hep.hr>
Subject: Re: POSIX-style regular expressions
Date: Tue, 10 Sep 2002 15:51:12 +0200
Organization: Hub.Org Networking Services (http://www.hub.org)
Lines: 40
Message-ID: <alktek$268u$1@news.hub.org>
References: 
 <Pine.BSO.4.44.0209100754190.3512-100000@kitten.greentechnologist.org>
To: pgsql-sql@postgresql.org

I tried to build retest but there was a lot of massages like

...... undefined referenc to ..

and building regex tester failed with messages

collect2: ld returned 1 exit status
make: *** [retest] Error 1


"Josh Jore" <josh@greentechnologist.org> wrote in message
news:Pine.BSO.4.44.0209100754190.3512-100000@kitten.greentechnologist.org...
> On Tue, 10 Sep 2002, Goran Buzic wrote:
>
> >     id1    char(6) NOT NULL CHECK(id1 ~* '^([0-9]{1,2}\.){2}$'),
>
> > 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.
>
> You should probably test it against PostgreSQL's regex engine. What you
> may not know is that they all have different syntaxes, rules and quirks.
> What works in one may or may not work in another.
>
> So check out src/backend/regex and build retest (I think that's what it
> was called). It's a command line regex tester (obviously against
> PostgreSQL's implementation).
>
> Joshua b. Jore -{ weird geeky madness }-> http://www.greentechnologist.org
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster