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.
Have a nice day,
Hi Marijn, Andreas,
I think Andreas is right, note the ordering of characters in the above
example as [ ^] rather than [^ ].
So if the '^' is taken as literal '^', can I check for the beginning of
a string in the brackets, or am I forced to use the (^| ) syntax?
Is it just me or are regular expressions crazy?
Howard
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
