Skip site navigation (1) Skip section navigation (2)

AREs in substring(from)

From: Brandon Craig Rhodes <brandon(at)oit(dot)gatech(dot)edu>
To: pgsql-general(at)postgresql(dot)org
Subject: AREs in substring(from)
Date: 2004-12-22 15:22:09
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-general
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               
Georgia Tech                                            brandon(at)oit(dot)gatech(dot)edu


pgsql-general by date

Next:From: Oleg BartunovDate: 2004-12-22 15:24:31
Subject: Re: PostgreSQL 8.0.0 Release Candidate 2
Previous:From: Pavel StehuleDate: 2004-12-22 15:17:29
Subject: valid using INITIALLY DEFERRED

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group