Postgres Pro
Downloads
Home   >   mailing lists

Thread: regexp help

regexp help

From
Garry Saddington
Date:
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

Re: regexp help

From
Said Ramirez
Date:
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
>

Re: regexp help

From
Charles Simard
Date:
|> -----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