From: | "George Woodman" <georgew(at)computerspecialists(dot)co(dot)za> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | BUG #3732: Select returns 0 rows for varchar field |
Date: | 2007-11-09 10:11:49 |
Message-ID: | 200711091011.lA9ABngk061355@wwwmaster.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
The following bug has been logged online:
Bug reference: 3732
Logged by: George Woodman
Email address: georgew(at)computerspecialists(dot)co(dot)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'
From | Date | Subject | |
---|---|---|---|
Next Message | Daniel Cristian Cruz | 2007-11-09 10:24:11 | Re: BUG #3731: ash table "PROCLOCK hash" corrupted |
Previous Message | Heikki Linnakangas | 2007-11-09 10:00:37 | Re: geometry data type |