Howard Cole wrote:
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
Sorry - I have just read the relevant section of the manual again and it
is starting to make sense. I shall use the (^| ) syntax as suggested.
Thanks for all the help.
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
