Thread: Problem with inet/cidr convert functions

Problem with inet/cidr convert functions

From
"Vadim I. Passynkov"
Date:
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

Re: Problem with inet/cidr convert functions

From
Tom Lane
Date:
"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