Try this:
hdbdev=> create table ips ( ip inet, ip_txt varchar(15) );
hdbdev=> insert into ips (ip,ip_txt) values ('192.168.1.1','192.168.1.1');
hdbdev=> select * from ips where ip like '192.168.1.1';
ip | ip_txt
----+--------
(0 rows)
hdbdev=> select * from ips where ip_txt like '192.168.1.1';
ip | ip_txt
-------------+-------------
192.168.1.1 | 192.168.1.1
(1 row)
That seems inconsistent?
--
Regards,
Phil
+------------------------------------------+
| Phil Mayers |
| Network & Infrastructure Group |
| Information & Communication Technologies |
| Imperial College |
+------------------------------------------+
