Thread

1. Problem with inet/cidr convert functions

   Vadim I. Passynkov <pvi@axxent.ca> — 2001-01-29T19:41:49Z

   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
   
   

2. Re: Problem with inet/cidr convert functions

   Tom Lane <tgl@sss.pgh.pa.us> — 2001-01-29T22:29:06Z

   "Vadim I. Passynkov" <pvi@axxent.ca> writes:
   > test=# select rpad ( host ( '127.0.0.1' ), 15 );
   >    rpad    
   > -----------
   >  127.0.0.1
   > (1 row)
   
   This is fixed in current sources (7.1beta4).
   
   			regards, tom lane