agora inbox for pgsql-sql@postgresql.org
help / color / mirror / Atom feedFrom: Andrew Sullivan <ajs@crankycanuck.ca>
To: pgsql-sql@postgresql.org
Subject: Re: Regular Expressions
Date: Wed, 21 Mar 2007 21:35:28 -0400
Message-ID: <20070322013528.GC29677@phlogiston.dyndns.org> (raw)
In-Reply-To: <46016D43.9030300@fastcon.com.br>
References: <46013B89.4040603@fastcon.com.br>
<1174487806.26600.15.camel@sigurd.incentre.net>
<46016D43.9030300@fastcon.com.br>
On Wed, Mar 21, 2007 at 02:37:07PM -0300, Ezequias R. da Rocha wrote:
> Great I am thinking of putting my like to rest. I felt it faster than
> "like" statement, have you any information about that ?
I think this rather depends on what you're doing.
If you're searching for "like 'blahblah%' or " ~ 'blahblah.*'",
they're AFAIK about the same. When you have a more complicated RE,
though, it might turn out to be a win.
A
--
Andrew Sullivan | ajs@crankycanuck.ca
Information security isn't a technological problem. It's an economics
problem.
--Bruce Schneier
view thread (18+ messages) latest in thread
Message-ID: <20070322013528.GC29677@phlogiston.dyndns.org>
Permalink: ../20070322013528.GC29677@phlogiston.dyndns.org/
Also on: postgresql.org/message-id/20070322013528.GC29677@phlogiston.dyndns.org
reply
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: ajs@crankycanuck.ca
Subject: Re: Regular Expressions
In-Reply-To: <20070322013528.GC29677@phlogiston.dyndns.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox