|> -----Original Message----- |> From: pgsql-general-owner@xxxxxxxxxxxxxx |> [mailto:pgsql-general-owner@xxxxxxxxxxxxxx]On Behalf Of |> Garry Saddington |> Sent: 9 juillet 2008 15:31 |> To: pgsql-general@xxxxxxxxxxxxxx |> 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@xxxxxxxxxxxxxx) |> To make changes to your subscription: |> http://www.postgresql.org/mailpref/pgsql-general |> SELECT substring(addressline1 from '(^[^0-9]+)') from addresses Cordialement, Charles Simard
