Re: 7.2 search/replace pl/pgsql

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: Nabil Sayegh <postgresql(at)e-trolley(dot)de>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: 7.2 search/replace pl/pgsql
Date: 2003-04-06 18:15:44
Message-ID: 200304061115.44945.josh@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Nabil,
> Great, exactly what i was looking for.
>
> Any idea how to use subexpressions ?
> like:
>
> $_="<A href=\"blah\">"
> s/"[^"]*"/$1/

You could pick up a copy of "Leaning Perl". PL/perl implements your host
system's perl library.

Keep in mind, though that any single quotes or backslashes in your expression
will have to be escaped in your function.

--
-Josh Berkus
Aglio Database Solutions
San Francisco

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Nabil Sayegh 2003-04-06 19:08:04 Re: 7.2 search/replace pl/pgsql
Previous Message Josh Berkus 2003-04-06 16:58:18 Re: 7.2 search/replace pl/pgsql