Re: [BUGS] BUG #3732: Select returns 0 rows for varchar field

2007-11-09 Thread Alvaro Herrera
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'

Re: [BUGS] BUG #3732: Select returns 0 rows for varchar field

2007-11-09 Thread Heikki Linnakangas
George Woodman wrote: I created a table with the following specs. CREATE TABLE user_control ( uci character varying(10) NOT NULL, ucname character varying(20), ucpwd character varying(10), ucrole character varying(20), CONSTRAINT user_control_pkey PRIMARY KEY (uci) ) WITH (OIDS=FALSE);