|> -----Original Message----- |> From: [EMAIL PROTECTED] |> [mailto:[EMAIL PROTECTED] 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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
