empty result on SELECT with LIKE on '...Z%'
thil <lor.thi@libertysurf.fr>
From: thil <lor.thi@libertysurf.fr>
To: pgsql-bugs@postgresql.org
Date: 2000-11-28T16:01:25Z
Lists: pgsql-bugs
I have a table with name of people. In this table there is 'MENDEZ PATRICIA' If I try SELECT * FROM people WHERE nom LIKE 'MEND%' result => MENDEZ PATRICIA If I try SELECT * FROM people WHERE nom LIKE 'MENDEZ%' result => empty (here is the problem) If I try SELECT * FROM people WHERE nom LIKE 'MENDEZ P%' result => MENDEZ PATRICIA Thank for this beautiful database. thil