On 10/31/10 12:28 PM, Radu Ilies wrote:
id, char[25]
name, text
The first row is:
id='radu'
name='Radu Ilies'
The following queries does not find any result (fail):
SELECT * FROM my_table WHERE id LIKE 'radu'
SELECT * FROM my_table WHERE id ILIKE 'radu'
'radu'::char[25] ==> 'radu__
The following bug has been logged online:
Bug reference: 5737
Logged by: Radu Ilies
Email address: ilies.r...@gmail.com
PostgreSQL version: 8.3.11
Operating system: NetBSD
Description:LIKE and ILIKE strange behaviour
Details:
Hello,
I have a table with:
id, char[2
