Ok , I've used .....,'\\M.*','') tks again
>From: "Luis Silva" <lfs12@hotmail.com>
>To: andreas.kretschmer@schollglas.com, pgsql-novice@postgresql.org
>Subject: Re: [NOVICE] substring result
>Date: Mon, 13 Feb 2006 15:36:06 +0000
>
>HI!!! that worked fine, but is it possible to get 'name' and 'address'
>using the regexp_replace too? TKS A LOT again
>
>>From: "A. Kretschmer" <andreas.kretschmer@schollglas.com>
>>To: pgsql-novice@postgresql.org
>>Subject: Re: [NOVICE] substring result
>>Date: Mon, 13 Feb 2006 13:06:28 +0100
>>
>>am 13.02.2006, um 10:53:48 +0000 mailte Luis Silva folgendes:
>> >
>> > I there!! I'm trying to use regular expressions with postgresql. My
>> > objective is to get from a long string the information that I need.
>> > For example
>> >
>> > "name='joe' , address='portugal' " and I need to get 'joe' and
>>'portugal'.
>> > can I do it with select substring()? if I can,how? tks a lot
>>
>>test=# select * from foo;
>> string
>>---------------------------------
>> name='joe' , address='portugal'
>>(1 row)
>>
>>
>>Write a function:
>>- count the fields separeted by ',' and then for every field:
>>
>>
>>test=# select regexp_replace(split_part(string,',',1), '\\m.*=', '') from
>>foo;
>> regexp_replace
>>----------------
>> 'joe'
>>(1 row)
>>
>>test=# select regexp_replace(split_part(string,',',2), '\\m.*=', '') from
>>foo;
>> regexp_replace
>>----------------
>> 'portugal'
>>(1 row)
>>
>>
>>You can with trim() remove spaces if you need.
>>
>>
>>
>>HTH, Andreas
>>--
>>Andreas Kretschmer (Kontakt: siehe Header)
>>Heynitz: 035242/47215, D1: 0160/7141639
>>GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net
>> === Schollglas Unternehmensgruppe ===
>>
>>---------------------------(end of broadcast)---------------------------
>>TIP 6: explain analyze is your friend
>
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 1: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly