[GENERAL] AREs in substring(from)

[Brandon Craig Rhodes]

As the documentation leads me to expect, my Postgresql 7.4
installation produces:

   select substring('Bar, Foo' FROM '.')  ->  'B'

but even though my regex_flavor = advanced,

   select substring('Bar, Foo' FROM '\\w')  ->  NULL
   select substring('Bar, Foo' FROM '***:\\w')  ->  NULL

whereas I expect these to produce 'B' as well.  What am I missing?

-- 
Brandon Craig Rhodes                         http://www.rhodesmill.org/brandon
Georgia Tech                                            [EMAIL PROTECTED]


---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])