我有以下问题,从表中返回的值在使用该值查询时不返回任何内容:

select * from my_table limit 2;
  id  |         zone         |     geo     
--------+----------------------+---------------
 9yjyyf |  America/Chicago     |  051059528002
 9yrw3j |  America/Chicago     |  050219503002

然后,当我在表上执行select count或select时,我得到一个空集作为结果:

select count(*) from my_table where geo = '051059528002';

 count 
-------
     0
(1 row)

这是表定义:

\d my_table 
      Table "public.my_table"
 Column |          Type          | Modifiers 
--------+------------------------+-----------
 id   | character varying(12)  | 
 zone   | character varying(100) | 
 geo  | character varying(32)  | 
Indexes:
    "geo_idx" btree (geoid)
    "id_idx" btree (tile)