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
