Re: regex from plperl

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: nonsolosoft(at)diff(dot)org
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: regex from plperl
Date: 2002-12-28 21:37:11
Message-ID: 4833.1041111431@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Ferruccio Zamuner" <nonsolosoft(at)diff(dot)org> writes:
> create or replace function dewey(text)
> returns text
> as '
> $_=shift;
> if (/(\d\d\d)/) {
> return "$1";
> } else {
> return("this is not a valid dewey!");
> }' language plperlu;

You need to double the backslashes.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message elein 2002-12-28 23:07:11 Re: RI Constraint display
Previous Message Tom Lane 2002-12-28 21:26:51 Re: 7.3.1: test select_having ... FAILED