substring result

From: "Luis Silva" <lfs12(at)hotmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: substring result
Date: 2006-02-13 10:53:48
Message-ID: BAY18-F244DEDDD4E3820C14731C5B5070@phx.gbl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice


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

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message A. Kretschmer 2006-02-13 12:06:28 Re: substring result
Previous Message Ken Hagans 2006-02-13 03:42:55 Re: Return column value from previous and next row in a recordset