Re: Quick Regex Question

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: Whole Thread | Raw Message | 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

In response to

Browse pgsql-general by date

  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