| From: | Alvaro Herrera <alvherre(at)commandprompt(dot)com> |
|---|---|
| To: | George Woodman <georgew(at)computerspecialists(dot)co(dot)za> |
| Cc: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | Re: BUG #3732: Select returns 0 rows for varchar field |
| Date: | 2007-11-09 14:35:46 |
| Message-ID: | 20071109143546.GK2768@alvh.no-ip.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter Eisentraut | 2007-11-09 15:53:08 | Re: BUG #3735: Can't create xml-stylesheet processing instruction |
| Previous Message | Pedro Gimeno | 2007-11-09 14:23:13 | Revisiting BUG #3684: After dump/restore, schema PUBLIC always exists |