Re: match an IP address - Mailing list pgsql-general

From Joao Ferreira gmail
Subject Re: match an IP address
Date
Msg-id 1222165334.6786.82.camel@jmf-ubuntu
Whole thread Raw
In response to Re: match an IP address  (hubert depesz lubaczewski <depesz@depesz.com>)
List pgsql-general
thank you depesz

it seems a pretty good fix for my problem. Actually yestreday I came up
with something similar but your's is better.

cheers

joao

On Tue, 2008-09-23 at 09:26 +0200, hubert depesz lubaczewski wrote:
> On Mon, Sep 22, 2008 at 05:59:25PM +0100, Joao Ferreira gmail wrote:
> > I'm unable to build a LIKE or SIMILAR TO expression for matching and ip
> > address
> > 192.168.90.3
> > 10.3.2.1
> > any help please...
>
> use this regular expression:
>
> '^[0-9]{1,3}(.[0-9]{1,3}){3}$'
>
> warning: do not use "like" or "similar to".
> proper way to use it:
>
> select * from table where field ~ '^[0-9]{1,3}(.[0-9]{1,3}){3}$';
>
> this regexp is not 100% fault proof - it will happily return rows like:
> '300.999.998.7'
>
> but for most of the cases it should be enough. if you need it to match
> only ips, and filter out things like '300.999.999.999' - let me know.
>
> Best regards,
>
> depesz
>


pgsql-general by date:

Previous
From: Simon Riggs
Date:
Subject: Re: [ADMIN] 8.3.4 rpms for Opensuse10.3 64bit
Next
From: "Phoenix Kiula"
Date:
Subject: Re: match an IP address