regexp help

From: Garry Saddington <garry(at)schoolteachers(dot)co(dot)uk>
To: pgsql-general(at)postgresql(dot)org
Subject: regexp help
Date: 2008-07-09 19:30:48
Message-ID: 200807092030.48722.garry@schoolteachers.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I have the following simple regular expression:

"SELECT substring(addressline1 from '(^[0-9]+)') from addresses"

How could I find non-matches of this same pattern?
regards
Garry

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Said Ramirez 2008-07-09 19:33:01 Re: regexp help
Previous Message Matthew Dennis 2008-07-09 19:25:31 Re: array sort for varchar arrays?