Re: [GENERAL] regexp idea

2013-08-28 Thread Alvaro Herrera
AI Rumman escribió: > Thanks. That's awesome. > Do you have any good guide where I may get more knowledge on REGEXP? This book is awesome: http://regex.info/book.html -- Álvaro Herrerahttp://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services -- Sent

Re: [GENERAL] regexp idea

2013-08-27 Thread Rob Sargent
On 08/27/2013 02:04 PM, AI Rumman wrote: Thanks. That's awesome. Do you have any good guide where I may get more knowledge on REGEXP? On Tue, Aug 27, 2013 at 3:57 PM, Rob Sargent > wrote: On 08/27/2013 12:44 PM, AI Rumman wrote: Hi, I have a

Re: [GENERAL] regexp idea

2013-08-27 Thread AI Rumman
Thanks. That's awesome. Do you have any good guide where I may get more knowledge on REGEXP? On Tue, Aug 27, 2013 at 3:57 PM, Rob Sargent wrote: > On 08/27/2013 12:44 PM, AI Rumman wrote: > >> Hi, >> >> I have a string like: >> Gloucester Catholic vs. St. Augustine baseball, South Jersey Non-Pu

Re: [GENERAL] regexp idea

2013-08-27 Thread Rob Sargent
On 08/27/2013 12:44 PM, AI Rumman wrote: Hi, I have a string like: Gloucester Catholic vs. St. Augustine baseball, South Jersey Non-Public A final, June 5, 2013 I need to extract date part from the string. I used the follows: regexp_matches(title,'[.* ]+\ (Jul|August|Sep)[, a-zA-Z0-9]+' ) B

Re: [GENERAL] regexp idea

2013-08-27 Thread David Johnston
rummandba wrote > Hi, > > I have a string like: > Gloucester Catholic vs. St. Augustine baseball, South Jersey Non-Public A > final, June 5, 2013 > > I need to extract date part from the string. > > I used the follows: > regexp_matches(title,'[.* ]+\ (Jul|August|Sep)[, a-zA-Z0-9]+' ) > > But it

[GENERAL] regexp idea

2013-08-27 Thread AI Rumman
Hi, I have a string like: Gloucester Catholic vs. St. Augustine baseball, South Jersey Non-Public A final, June 5, 2013 I need to extract date part from the string. I used the follows: regexp_matches(title,'[.* ]+\ (Jul|August|Sep)[, a-zA-Z0-9]+' ) But it gives me result August as it stops at "