Thread

Problem with inet/cidr convert functions

Vadim I. Passynkov <vip@axxent.ca> — 2001-01-29T19:35:29Z

Hi All,

This is not working 
test=# select rpad ( host ( '127.0.0.1' ), 15 );
   rpad    
-----------
 127.0.0.1
(1 row)

This working OK
test=# select rpad ( host ( '127.0.0.1' ) || '', 15 );
      rpad       
-----------------
 127.0.0.1      
(1 row)


Other examples
test=# select now() where '127.0.0.1'::text = host ( '127.0.0.1' );
 now 
-----
(0 rows)

test=# select now() where '127.0.0.1'::text LIKE host ( '127.0.0.1' );
          now           
------------------------
 2001-01-29 14:33:37-05
(1 row)

test=# select now() where '127.0.0.1'::text = host ( '127.0.0.1' ) ||
'';
          now           
------------------------
 2001-01-29 14:32:04-05
(1 row)


-- 

 Vadim I. Passynkov, Axxent Corp.
 mailto:vip@axxent.ca