From: | "Goran Buzic" <goran(dot)buzic(at)hep(dot)hr> |
---|---|
To: | pgsql-sql(at)postgresql(dot)org |
Subject: | Re: POSIX-style regular expressions |
Date: | 2002-09-10 13:51:12 |
Message-ID: | alktek$268u$1@news.hub.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
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(at)greentechnologist(dot)org> wrote in message
news:Pine(dot)BSO(dot)4(dot)44(dot)0209100754190(dot)3512-100000(at)kitten(dot)greentechnologist(dot)org(dot)(dot)(dot)
> 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
From | Date | Subject | |
---|---|---|---|
Next Message | Ross J. Reedstrom | 2002-09-10 14:49:08 | Re: stored procedures: sybase -> postgreSQL ? |
Previous Message | Josh Jore | 2002-09-10 13:35:27 | Re: POSIX-style regular expressions |