Home > mailing lists

Regex substring help - Mailing list pgsql-general

From	Nick
Subject	Regex substring help
Date	September 3, 2009 22:50:19
Msg-id	3ecde714-8579-45d5-adc0-e816f0e0ea4c@d9g2000prh.googlegroups.com Whole thread Raw
Responses	Re: Regex substring help (David Fetter <david@fetter.org>)
List	pgsql-general

Tree view

Im trying to get all the text before the '<br>' tag.

SELECT SUBSTRING('one<br>two<br>three','(^.*)<br>.*$');

returns "one<br>two"

How do I get it to return "one"?

pgsql-general by date:

From: Jerry LeVan
Date: 03 September 2009, 22:20:58
Subject: Re: Snow Leopard and plpython problem

From: David Fetter
Date: 03 September 2009, 23:00:31
Subject: Re: Regex substring help

Regex substring help - Mailing list pgsql-general

Previous

Next