From: | "Vadim I(dot) Passynkov" <pvi(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:41:49 |
Message-ID: | 3A75C77D.499C5BF3@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:pvi(at)axxent(dot)ca
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2001-01-29 22:29:06 | Re: Problem with inet/cidr convert functions |
Previous Message | Vadim I. Passynkov | 2001-01-29 19:35:29 | Problem with inet/cidr convert functions |