BUG #3732: Select returns 0 rows for varchar field
От | George Woodman |
---|---|
Тема | BUG #3732: Select returns 0 rows for varchar field |
Дата | |
Msg-id | 200711091011.lA9ABngk061355@wwwmaster.postgresql.org обсуждение исходный текст |
Ответы |
Re: BUG #3732: Select returns 0 rows for varchar field
Re: BUG #3732: Select returns 0 rows for varchar field |
Список | pgsql-bugs |
The following bug has been logged online: Bug reference: 3732 Logged by: George Woodman Email address: georgew@computerspecialists.co.za PostgreSQL version: 8.2.5 Operating system: Windows 2000 Description: Select returns 0 rows for varchar field Details: 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); ALTER TABLE user_control OWNER TO postgres; GRANT ALL ON TABLE user_control TO postgres; 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'
В списке pgsql-bugs по дате отправления: