Re: [GENERAL] AREs in substring(from)

2004-12-22 Thread Tom Lane
Brandon Craig Rhodes <[EMAIL PROTECTED]> writes: > 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

[GENERAL] AREs in substring(from)

2004-12-22 Thread 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