Skip site navigation (1) Skip section navigation (2)

BUG #3732: Select returns 0 rows for varchar field

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 (view raw or flat)
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'

Responses

pgsql-bugs by date

Next:From: Daniel Cristian CruzDate: 2007-11-09 10:24:11
Subject: Re: BUG #3731: ash table "PROCLOCK hash" corrupted
Previous:From: Heikki LinnakangasDate: 2007-11-09 10:00:37
Subject: Re: geometry data type

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group