| From: | Patrick Welche <prlw1(at)newn(dot)cam(dot)ac(dot)uk> |
|---|---|
| To: | Nick Barr <nick(dot)barr(at)webbased(dot)co(dot)uk> |
| Cc: | csegyud(at)vnet(dot)hu, terry(at)ashtonwoodshomes(dot)com, "'Pgsql-General(at)Postgresql(dot)Org (E-mail)'" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Using regular expressions in LIKE |
| Date: | 2004-01-15 12:08:52 |
| Message-ID: | 20040115120852.GG5213@quartz.newn.cam.ac.uk |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Curt Sampson | 2004-01-15 12:14:23 | Solution to UPDATE or INSERT Problem |
| Previous Message | Michael Glaesemann | 2004-01-15 11:49:53 | Re: Bug and/or feature? Complex data types in tables... |