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.