Re: regex engine

From: Markus Bertheau <twanger(at)bluetwanger(dot)de>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Jean-Luc Lachance <jllachan(at)sympatico(dot)ca>, Keith Gallant <keith(at)justhosting(dot)ca>, pgsql-sql(at)postgresql(dot)org
Subject: Re: regex engine
Date: 2004-07-25 19:07:35
Message-ID: 1090782455.9204.8.camel@teetnang
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

В Вск, 25.07.2004, в 19:34, Tom Lane пишет:
> Markus Bertheau <twanger(at)bluetwanger(dot)de> writes:
> > В Вск, 25.07.2004, в 16:40, Jean-Luc Lachance пишет:
> >> Better yet:
> >>
> >> SELECT * FROM table WHERE phrase ~ '^[0-9]';
>
> > Not so sure if that's better - the regex engines aren't the fastest.
>
> [ raised eyebrow... ] I was under the impression that we had a pretty
> good one as of PG 7.4. Have you tested it lately?

I wasn't trying to say that pg's regex engine was particularly slow, but
that regex engines in general are slower than an exact substring search.
If I'm mistaken here, please tell. pg's regex engine does have one
shortcoming though: it doesn't know UTF-8.

--
Markus Bertheau <twanger(at)bluetwanger(dot)de>

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2004-07-25 19:41:21 Re: regex engine
Previous Message Tom Lane 2004-07-25 17:34:21 Re: SELECT from a list