Identifying Reason for Column Name Returned by SELECT
От | Rich Shepard |
---|---|
Тема | Identifying Reason for Column Name Returned by SELECT |
Дата | |
Msg-id | alpine.LNX.2.00.1109140929020.4384@salmo.appl-ecosys.com обсуждение исходный текст |
Ответы |
Re: Identifying Reason for Column Name Returned by SELECT
Re: Identifying Reason for Column Name Returned by SELECT |
Список | pgsql-general |
I run this SELECT statement on a table: select distinct(site_id) from chemistry order by site_id; and in the returned set I see: GW-21 GW-22 GW-22 + GW-24 I want to find that row returning 'GW-22 +' because I believe it should be 'GW-23'. However, my attempts to retrieve that row keep failing. I've tried these statements: select count(*) from chemistry where site_id = 'GW-22 +'; count ------- 0 (1 row) yet, select count(*) from chemistry where site_id = 'GW-22'; count ------- 803 (1 row) Looking for the blank row also fails when I try to specify site_id as is null, = ' ', or =''. Please point me to the proper way of finding this rogue row so I can correct the value in the site_id column. TIA, Rich
В списке pgsql-general по дате отправления: