Re: Using regular expressions in LIKE - Mailing list pgsql-general

From Patrick Welche
Subject Re: Using regular expressions in LIKE
Date
Msg-id 20040115120852.GG5213@quartz.newn.cam.ac.uk
Whole thread Raw
In response to Re: Using regular expressions in LIKE  ("Nick Barr" <nick.barr@webbased.co.uk>)
List pgsql-general
On Thu, Jan 15, 2004 at 09:05:35AM -0000, Nick Barr wrote:
> If the ^ was not there then it could theoretically match anywhere in the
> string. In this particular case the regular expression will probably
> match at the beginning of the string anyway, so it is not really
> necessary. I prefer to put that sort of thing in to make it clear to the
> programmer what is going on.

Isn't there also a performance benefit as you can use an index if you
say "this definitely starts at the beginning" with the '^'?

Cheers,

Patrick

pgsql-general by date:

Previous
From: Michael Glaesemann
Date:
Subject: Re: Bug and/or feature? Complex data types in tables...
Next
From: "Nick Barr"
Date:
Subject: Re: Using regular expressions in LIKE