I suspect you have a multi-line entry and the '+' is just indicating
that the field continues.
Try ...where site_id ~ 'GW-22'... (this may take a while if the table is
very large).
Cheers,
Steve
On 09/14/2011 09:35 AM, Rich Shepard wrote:
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
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
