Skip site navigation (1) Skip section navigation (2)

Problem with inet/cidr convert functions

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 (view raw or flat)
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

Responses

pgsql-bugs by date

Next:From: Tom LaneDate: 2001-01-29 22:29:06
Subject: Re: Problem with inet/cidr convert functions
Previous:From: Vadim I. PassynkovDate: 2001-01-29 19:35:29
Subject: Problem with inet/cidr convert functions

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group