Re: BUG #3732: Select returns 0 rows for varchar field - Mailing list pgsql-bugs

George Woodman wrote:

> I have 2 records with the following details:
> george,George,george,developer
> 1234567890,Temp,0,developer
> When I try to retrieve this record with the following statement from a
> ASP.Net (VB) app I get no rows returned.
> Select * from user_control where uci = 'george'
> However this statement works.
> Select * from user_control where uci = '1234567890'

Are you sure 'george' does not have whitespace at the end?  My bet is
that it is actually 'george    '

--
Alvaro Herrera                 http://www.amazon.com/gp/registry/CTMLCN8V17R4
"Postgres is bloatware by design: it was built to house
 PhD theses." (Joey Hellerstein, SIGMOD annual conference 2002)