Re: [BUGS] Replace function BUG

2004-07-17 Thread Theodore Petrosky
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 Bottar

Re: [BUGS] Replace function BUG

2004-07-16 Thread Tom Lane
Stephan Szabo <[EMAIL PROTECTED]> writes: > On Tue, 13 Jul 2004, Nicolas Bottarini wrote: >> In postgreSQL 7.3.2 when I execute the following query >> >> select replace('test %400% result', 'result', 'ok'); >> >> it returns "test % ok" > I think this was fixed in the 7.4 branch. It was fixed in

Re: [BUGS] Replace function BUG

2004-07-16 Thread Stephan Szabo
On Tue, 13 Jul 2004, Nicolas Bottarini wrote: > In postgreSQL 7.3.2 when I execute the following query > > select replace('test %400% result', 'result', 'ok'); > > it returns "test % ok" I think this was fixed in the 7.4 branch. ---(end of broadcast)-

[BUGS] Replace function BUG

2004-07-16 Thread Nicolas Bottarini
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 pl