Re: POSIX-style regular expressions

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

In response to

Responses

Browse pgsql-sql by date

  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