From: Goran Buzic <goran.buzic@hep.hr>
To: pgsql-sql@postgresql.org
Subject: Re: POSIX-style regular expressions
Date: Tue, 10 Sep 2002 15:51:12 +0200
Message-ID: <alktek$268u$1@news.hub.org> (raw)
References: <Pine.BSO.4.44.0209100754190.3512-100000@kitten.greentechnologist.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
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: goran.buzic@hep.hr
Subject: Re: POSIX-style regular expressions
In-Reply-To: <alktek$268u$1@news.hub.org>
* 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