Re: [GENERAL] regexp_matches question SOLVED

2012-09-06 Thread Sergio Basurto
On Wed, 2012-09-05 at 21:15 -0400, David Johnston wrote: > On Sep 5, 2012, at 19:02, Sergio Basurto > wrote: > > > > > On Tue, 2012-09-04 at 21:58 -0400, David Johnston wrote: > > > > > On Sep 4, 2012, at 21:39, Sergio Basurto wrote: > > > &g

Re: [GENERAL] regexp_matches question

2012-09-06 Thread Sergio Basurto
On Tue, 2012-09-04 at 21:58 -0400, David Johnston wrote: > On Sep 4, 2012, at 21:39, Sergio Basurto wrote: > > > I am using regexp_matches in a function like this > > > > create or replace function test (v_string in text) returns varchar as > >

Re: [GENERAL] regexp_matches question

2012-09-05 Thread Sergio Basurto
On Tue, 2012-09-04 at 21:58 -0400, David Johnston wrote: > On Sep 4, 2012, at 21:39, Sergio Basurto wrote: > > > I am using regexp_matches in a function like this > > > > create or replace function test (v_string in text) returns varchar as > >

[GENERAL] regexp_matches question

2012-09-04 Thread Sergio Basurto
I am using regexp_matches in a function like this create or replace function test (v_string in text) returns varchar as $$ declare i_strings text[]; i_stringtext[]; i_strings := regexp_matches(v_string,E'[a-zA-Z0-9:\\s\\-\\.#% ]*:[A-Za-z0-9\\s\\-\\.#%]+