On 23/02/07, Anton Melser <melser.anton@xxxxxxxxx> 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.
