Re: [SQL] Problem using IP functions

2001-05-12 Thread Tom Lane
"Marc Lamothe" <[EMAIL PROTECTED]> writes: > The subnet_number column is a varchar(16) which I assume you can compare > with a text data type, which is what host() returns. Are you on a pre-7.1 Postgres release? host() is buggy before 7.1 --- it includes a trailing null in its output, which it s

[SQL] Problem using IP functions

2001-05-12 Thread Marc Lamothe
Hi, I'm having trouble using the host() and netmask() functions within a select query. For some reason, the following query returns 1 row: ipdb=> select id, subnet_number from subnet where subnet_number = '216.46.13.0'; id | subnet_number +--- 96 | 216.46.13.0 (1 row) Yet, if