Skip site navigation (1) Skip section navigation (2)

Re: select all matches for a regular expression ?

From: "Anton Melser" <melser(dot)anton(at)gmail(dot)com>
To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: select all matches for a regular expression ?
Date: 2007-02-23 15:18:39
Message-ID: 92d3a4950702230718s18c4854ax8034cc49a2a1f6b0@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-general
On 23/02/07, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> "Anton Melser" <melser(dot)anton(at)gmail(dot)com> writes:
> > I need to be able to get all the matches for a particular regexp from
> > a text field that I need to use in another query in a function. Is
> > this possible with plpgsql? Do I have to install the perl language?
>
> You need plperl (or pltcl; likely plpython would work too) --- the
> built-in regex functions don't have any way to return more than the
> first match.  There's a patch pending to provide more functionality
> here for 8.3, but it won't help you today.

Thanks for the info
Cheers
Anton

In response to

Responses

pgsql-general by date

Next:From: Tom LaneDate: 2007-02-23 15:19:07
Subject: Re: false unique constraint error...for me
Previous:From: Joris DobbelsteenDate: 2007-02-23 15:10:07
Subject: Re: complex referential integrity constraints

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group