Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: select all matches for a regular expression ?
- From: "Peter Childs" <peterachilds(at)gmail(dot)com>
- Cc: pgsql-general(at)postgresql(dot)org
- Subject: Re: select all matches for a regular expression ?
- Date: Fri, 23 Feb 2007 14:14:03 +0000
- Message-id: <a2de01dd0702230614rc647383q50ca083d6541a68b(at)mail(dot)gmail(dot)com>
On 23/02/07, Anton Melser <melser(dot)anton(at)gmail(dot)com> wrote:
Hi, 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? Cheers Anton ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
yes. use "like" or "~" see http://www.postgresql.org/docs/8.2/static/functions-matching.html There is no need to use perl. Peter.
- Follow-Ups:
- Re: select all matches for a regular expression ?
- From: Anton Melser
- Re: select all matches for a regular expression ?
- References:
- select all matches for a regular expression ?
- From: Anton Melser
- select all matches for a regular expression ?
- Prev by Date: ODBCng and OpenOffice 2.1
- Next by Date: Re: Warning "TupleDesc reference leak"
- Previous by thread: select all matches for a regular expression ?
- Next by thread: Re: select all matches for a regular expression ?
- Indexes: