Problem with inet/cidr convert functions

From: "Vadim I(dot) Passynkov" <vip(at)axxent(dot)ca>
To: "pgsql-bugs(at)postgresql(dot)org" <pgsql-bugs(at)postgresql(dot)org>
Subject: Problem with inet/cidr convert functions
Date: 2001-01-29 19:35:29
Message-ID: 3A75C601.D9CCD2F@axxent.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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:vip(at)axxent(dot)ca

Browse pgsql-bugs by date

  From Date Subject
Next Message Vadim I. Passynkov 2001-01-29 19:41:49 Problem with inet/cidr convert functions
Previous Message Tom Lane 2001-01-29 17:20:13 Re: Create index problem ( _bt_sort )