| 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
| 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 ) |