You can probably use [^0-9]
-Said
Garry Saddington wrote:
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
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
