From: Bruce Momjian <pgman@candle.pha.pa.us>
Message-Id: <200209161555.g8GFtr213233@candle.pha.pa.us>
Subject: Re: POSIX-style regular expressions
In-Reply-To: <alktek$268u$1@news.hub.org>
To: Goran Buzic <goran.buzic@hep.hr>
Date: Mon, 16 Sep 2002 11:55:53 -0400 (EDT)
Cc: pgsql-sql@postgresql.org
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Type: text/plain; charset=US-ASCII


I have commented out the Makefile entry for retest because I can't get
it to compile anymore.  Someone can come along and clean it up someday.

# retest will not compile because multibyte is now enabled by default
# and the multibyte calls require /mmgr, /adt, and other calls that
# are complex for linkage,  bjm 2002-09-16
#retest: retest.o SUBSYS.o $(DEBUGOBJ)
#       $(CC) $(CFLAGS) $(LDFLAGS) $^ $(LIBS) -o $@

---------------------------------------------------------------------------

Goran Buzic wrote:
> 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
> 
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly
> 

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073