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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>