On Mon, Sep 22, 2008 at 10:59 AM, Joao Ferreira gmail <[EMAIL PROTECTED]> wrote: > hello all, > > I'm unable to build a LIKE or SIMILAR TO expression for matching and ip > address > > 192.168.90.3 > 10.3.2.1
As already mentioned inet / cidr types should work. Example: postgres=# create table inettest (a inet); CREATE TABLE postgres=# insert into inettest values ('192.168.0.1'),('192.168.1.1'),('10.0.0.1'); INSERT 0 3 postgres=# select a from inettest where '192.168.0.1/16' >> a; a ------------- 192.168.0.1 192.168.1.1 (2 rows) postgres=# select a from inettest where '192.168.0.1/24' >> a; a ------------- 192.168.0.1 (1 row) postgres=# select a from inettest where '192.168.0.1/0' >> a; a ------------- 192.168.0.1 192.168.1.1 10.0.0.1 (3 rows) -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general