Re: regex in plpgsql function

From: Culley Harrelson <culley(at)fastmail(dot)fm>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: regex in plpgsql function
Date: 2004-01-22 18:10:42
Message-ID: 20040122181042.GE29114@abcteach.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

>
> I think you have to double the \s again in the function so that there
> are 4 \s for each \ in the RE.

Thanks. This worked:

RETURN $1 ~
''^[[:alnum:]_]+[[:space:]]+[[:alnum:]_]?\\.?[[:space:]]?[[:alnum:]_]+$'';

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Rick Gigger 2004-01-22 18:26:03 Re: embedded/"serverless" (Re: serverless postgresql)
Previous Message Tom Lane 2004-01-22 18:10:05 Re: tablespaces a priority for 7.5?