Re: [BUGS] BUG #4865: replace function returns null

2009-06-19 Thread Tom Lane
"Jamolkhon Khakimov" writes: > replace( 'abcdefabcdef', 'XX', null) > // returns null, while it should return 'abcdefabcdef' No, it should return null. Like most Postgres functions, replace is strict, meaning it returns null if any input is null. This is sensible in the abstract because an unkn

[BUGS] BUG #4865: replace function returns null

2009-06-19 Thread Jamolkhon Khakimov
The following bug has been logged online: Bug reference: 4865 Logged by: Jamolkhon Khakimov Email address: jkhaki...@gmail.com PostgreSQL version: 8.2.7 Operating system: Linux Description:replace function returns null Details: I dont know if it's a bug or not. It j