am Thu, dem 20.12.2007, um 12:03:57 +0100 mailte Martijn van Oosterhout folgendes: > 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. I know, but only if the ^ at the beginning, or no? Andreas -- Andreas Kretschmer Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header) GnuPG-ID: 0x3FFF606C, privat 0x7F4584DA http://wwwkeys.de.pgp.net ---------------------------(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