Postgres Pro
Downloads
Home   >   mailing lists

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

From hubert depesz lubaczewski
Subject Re: match an IP address
Date
Msg-id 20080922170252.GA8317@depesz.com
Whole thread Raw
In response to match an IP address  (Joao Ferreira gmail <joao.miguel.c.ferreira@gmail.com>)
List pgsql-general
Tree view 
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...

any reason not to use standard inet datatype? which does the validation.

Best regards,

depesz

--
Linkedin: http://www.linkedin.com/in/depesz  /  blog: http://www.depesz.com/
jid/gtalk: depesz@depesz.com / aim:depeszhdl / skype:depesz_hdl / gg:6749007

pgsql-general by date:

Previous
From: Joao Ferreira gmail
Date:
Subject: match an IP address
Next
From: Raymond O'Donnell
Date:
Subject: Re: match an IP address