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"?
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
