empty result on SELECT with LIKE on '...Z%'

From: thil <lor(dot)thi(at)libertysurf(dot)fr>
To: pgsql-bugs(at)postgresql(dot)org
Subject: empty result on SELECT with LIKE on '...Z%'
Date: 2000-11-28 16:01:25
Message-ID: 00112817012500.00960@pc250
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2000-11-28 18:49:49 Re: PortalHeapMemoryFree...in diskless client
Previous Message Tom Lane 2000-11-28 15:42:49 Re: PortalHeapMemoryFree...in diskless client