From: Markus Bertheau <twanger@bluetwanger.de>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Jean-Luc Lachance <jllachan@sympatico.ca>
Cc: Keith Gallant <keith@justhosting.ca>
Cc: pgsql-sql@postgresql.org
Subject: Re: regex engine
Date: Sun, 25 Jul 2004 21:07:35 +0200
Message-ID: <1090782455.9204.8.camel@teetnang> (raw)
In-Reply-To: <14659.1090776861@sss.pgh.pa.us>
References: <PDENIKIKNMLHOJKGJDLGCEPCCGAA.keith@justhosting.ca>
<1090763779.9204.1.camel@teetnang>
<4103C656.4070109@sympatico.ca>
<1090772515.9204.3.camel@teetnang>
<14659.1090776861@sss.pgh.pa.us>
В Вск, 25.07.2004, в 19:34, Tom Lane пишет:
> Markus Bertheau <twanger@bluetwanger.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@bluetwanger.de>
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: twanger@bluetwanger.de, tgl@sss.pgh.pa.us, jllachan@sympatico.ca, keith@justhosting.ca
Subject: Re: regex engine
In-Reply-To: <1090782455.9204.8.camel@teetnang>
* 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