From: | Florian Aumeier <faumeier(at)mediaventures(dot)de> |
---|---|
To: | Howard Cole <howardnews(at)selestial(dot)com> |
Cc: | 'PgSql General' <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Quick Regex Question |
Date: | 2007-12-20 10:10:08 |
Message-ID: | 476A3F80.5020004@mediaventures.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
hi
> select 'Ho Ho Ho' ~* '^Ho'; returns true
> select 'Ho Ho Ho' ~* ' Ho'; returns true
> select 'Ho Ho Ho' ~* '[^ ]Ho'; returns false (Please note there is a
> space between ^ and ])
"A /bracket expression/ is a list of characters enclosed in []. It
normally matches any single character from the list (but see below). If
the list begins with ^, it matches any single character /not/ from the
rest of the list."
from:
http://www.postgresql.org/docs/8.3/static/functions-matching.html#POSIX-BRACKET-EXPRESSIONS
Regards
Florian
--
Media Ventures GmbH
Jabber-ID faumeier(at)mabber(dot)de
Telefon +49 (0) 2236 480 10 22
From | Date | Subject | |
---|---|---|---|
Next Message | Richard Huxton | 2007-12-20 10:11:01 | Re: Quick Regex Question |
Previous Message | Howard Cole | 2007-12-20 09:56:00 | Quick Regex Question |