| From: | Bruce Momjian <bruce(at)momjian(dot)us> |
|---|---|
| To: | JORGE MALDONADO <jorgemal1960(at)gmail(dot)com> |
| Cc: | pgsql-novice(at)postgresql(dot)org |
| Subject: | Re: DIFFERENCE BETWEEN LIKE AND SIMILAR OPERATORS |
| Date: | 2010-03-16 01:31:43 |
| Message-ID: | 201003160131.o2G1VhP25162@momjian.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
JORGE MALDONADO wrote:
> I've been reading PostgreSQL documentation and I do not really understand
> the difference between LIKE and SIMILAR operators. Can someone explain?
SIMILAR is a super-set of LIKE syntax. Our docs have:
http://developer.postgresql.org/pgdocs/postgres/functions-matching.html#FUNCTIONS-SIMILARTO-REGEXP
It is similar to LIKE, except that it interprets the pattern using the
SQL standard's definition of a regular expression. SQL regular
expressions are a curious cross between LIKE notation and common regular
expression notation.
For the super-set, see the bullets below this line:
In addition to these facilities borrowed from LIKE, SIMILAR TO
supports these pattern-matching metacharacters borrowed from POSIX
regular expressions:
--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com
PG East: http://www.enterprisedb.com/community/nav-pg-east-2010.do
| From | Date | Subject | |
|---|---|---|---|
| Next Message | John Gage | 2010-03-16 05:27:40 | Re: DIFFERENCE BETWEEN LIKE AND SIMILAR OPERATORS |
| Previous Message | JORGE MALDONADO | 2010-03-16 01:25:09 | DIFFERENCE BETWEEN LIKE AND SIMILAR OPERATORS |