well... my IP addresses are stored in a TEXT type field. that field can actually contain usernames like 'joao' or 'scott' and it can contain IP addresses....
:( joao On Mon, 2008-09-22 at 11:13 -0600, Scott Marlowe wrote: > 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