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

Re: Replace function BUG

From: Theodore Petrosky <tedpet5(at)yahoo(dot)com>
To: Nicolas Bottarini <nicolas(at)avatarla(dot)com>,pgsql-bugs(at)postgresql(dot)org
Subject: Re: Replace function BUG
Date: 2004-07-17 15:39:05
Message-ID: 20040717153905.17529.qmail@web41006.mail.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-bugs
7.4.2 gives it like this:

testbed=# select replace('test %%400%% result',
'result', 'ok');
     replace     
-----------------
 test %%400%% ok
(1 row)

testbed =# select replace('test %400% result',
'result', 'ok');
    replace    
---------------
 test %400% ok
(1 row)

Ted



-- Nicolas Bottarini <nicolas(at)avatarla(dot)com> wrote:
> In postgreSQL 7.3.2 when I execute the following
> query
> 
> select replace('test %400% result', 'result', 'ok');
> 
>  
> 
> it returns "test % ok"
> 
>  
> 
> And If I Execute:
> 
> select replace('test %%400%% result', 'result',
> 'ok');
> 
> it returns the correct result: "test %400% ok"
> 
>  
> 
> If this is a known BUG please tell me because I need
> to fix this.
> 
>  
> 
> Thanks
> 
>  
> 
> Nicolas Bottarini
> 
>  
> 
> 


		
__________________________________
Do you Yahoo!?
Vote for the stars of Yahoo!'s next ad campaign!
http://advision.webevents.yahoo.com/yahoo/votelifeengine/


In response to

pgsql-bugs by date

Next:From: Tom LaneDate: 2004-07-17 16:12:00
Subject: Re: Problems renaming referencing column
Previous:From: Stephan SzaboDate: 2004-07-17 15:08:52
Subject: Re: Problems renaming referencing column

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