Re: Quick Regex Question - Mailing list pgsql-general

From Richard Huxton
Subject Re: Quick Regex Question
Date
Msg-id 476A4E7F.1010504@archonet.com
Whole thread Raw
In response to Re: Quick Regex Question  (Martijn van Oosterhout <kleptog@svana.org>)
List pgsql-general
Martijn van Oosterhout wrote:
> On Thu, Dec 20, 2007 at 11:51:34AM +0100, A. Kretschmer wrote:
>> am  Thu, dem 20.12.2007, um 10:36:08 +0000 mailte Howard Cole folgendes:
>>> Your expression works fine Richard, as does '(^| )ho', but can you tell
>>> me why '[ ^]ho' doesn't work?
>> With ^ you means an anchor, but within the brackets it's a simple char.
>
> Err no, it inverts the test. [^ ] means any character *except* a space.

But only if it's the first character within the brackets.

Which is the opposite of how "-" behaves inside square-brackets of course.

Aren't regexps fun :-)

--
   Richard Huxton
   Archonet Ltd

pgsql-general by date:

Previous
From: Karsten Hilbert
Date:
Subject: Re: Postgres 8.3 HOT and non-persistent xids
Next
From: Andrew Nesheret
Date:
Subject: Re: foreign key constraint, planner ignore index.