Re: substring result

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 ===