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);

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

2007-11-09 Thread George Woodman
The following bug has been logged online: Bug reference: 3732 Logged by: George Woodman Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2.5 Operating system: Windows 2000 Description:Select returns 0 rows for varchar field Details: I created a table with the