regexp help

You can probably use [^0-9]
-Said

Garry Saddington wrote:

|> -----Original Message-----
|> From: pgsql-general-owner@postgresql.org
|> [mailto:pgsql-general-owner@postgresql.org]On Behalf Of
|> Garry Saddington
|> Sent: 9 juillet 2008 15:31
|> To: pgsql-general@postgresql.org
|> Subject: [GENERAL] regexp help
|>
|>
|> 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
|>

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

Cordialement,

Charles Simard