Обсуждение: 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
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 >
|> -----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