Re: inet types and LIKE doesn't work as expected

Phil Mayers wrote:

> 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?

The default text conversion for the inet type includes a mask:

test=# select text(ip) from ips;
      text
----------------
 192.168.1.1/32
(1 row)

so

 select * from ips where ip like '192.168.1.1%';

works as expected.

The joys of semanically rich data types :-)


Hope this helps a little.


Allan.