| From: | Rich Shepard <rshepard(at)appl-ecosys(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Identifying Reason for Column Name Returned by SELECT |
| Date: | 2011-09-14 16:35:00 |
| Message-ID: | alpine.LNX.2.00.1109140929020.4384@salmo.appl-ecosys.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Steve Crawford | 2011-09-14 16:42:31 | Re: Identifying Reason for Column Name Returned by SELECT |
| Previous Message | Antonio Vieiro | 2011-09-14 15:58:58 | Re: Bit datatype performance? |