Re: [GENERAL] regexp help

2008-07-09 Thread Charles Simard
|> -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 regu

Re: [GENERAL] regexp help

2008-07-09 Thread Said Ramirez
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@po

[GENERAL] regexp help

2008-07-09 Thread Garry Saddington
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://ww