Skip site navigation (1) Skip section navigation (2)

Re: Regular Expressions

From: Andrew Sullivan <ajs(at)crankycanuck(dot)ca>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: Regular Expressions
Date: 2007-03-22 01:35:28
Message-ID: 20070322013528.GC29677@phlogiston.dyndns.org (view raw or flat)
Thread:
Lists: pgsql-sql
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(at)crankycanuck(dot)ca
Information security isn't a technological problem.  It's an economics
problem.
		--Bruce Schneier

In response to

pgsql-sql by date

Next:From: Hubertus Freiherr von FuerstenbergDate: 2007-03-22 10:40:11
Subject: Re: growth of the database
Previous:From: George PavlovDate: 2007-03-21 22:25:05
Subject: Re: [SQL] Monitor what command is executing at the backend

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group