Re: substring and POSIX re's

On Tue, Apr 19, 2005 at 12:39:52PM -0400, Alvaro Herrera wrote:
> On Tue, Apr 19, 2005 at 10:03:45AM -0600, Michael Fuhr wrote:
> > On Tue, Apr 19, 2005 at 11:17:46AM -0500, Don Isgitt wrote:
> > >
> > > Thanks, Tom. Interestingly enough, neither my original query or your
> > > corrected one returns anything with pg 7.4--another good reason to
> > > upgrade to 8.*
> >
> > Hmmm...for me both queries give the results shown if I run them in
> > 7.3.9, 7.4.7, 8.0.2, or 8.1devel. What's different about your 7.4
> > installation?
>
> Maybe the regex_flavor setting? (not sure of the exact name)

Ah yes, I forgot about that....

test=> SET regex_flavor TO basic;
SET
test=> SELECT substring('NE NE SE 2310 FSL 330 FEL' FROM '^(([A-Z][A-Z] )+)');
substring
-----------

(1 row)

test=> SET regex_flavor TO advanced;
SET
test=> SELECT substring('NE NE SE 2310 FSL 330 FEL' FROM '^(([A-Z][A-Z] )+)');
substring
-----------
NE NE SE
(1 row)

test=> SELECT version();
version
---------------------------------------------------------------------------
PostgreSQL 7.4.7 on sparc-sun-solaris2.9, compiled by GCC gcc (GCC) 3.4.2
(1 row)

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/