Horton

Problem with inet/cidr convert functions

Vadim I. Passynkov <pvi@axxent.ca>

View thread
From: "Vadim I. Passynkov" <pvi@axxent.ca>
To: "pgsql-bugs@postgresql.org" <pgsql-bugs@postgresql.org>
Date: 2001-01-29T19:41:49Z
Lists: pgsql-bugs 
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:pvi@axxent.ca