Appended '+' in Column Value

From: Rich Shepard <rshepard(at)appl-ecosys(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Appended '+' in Column Value
Date: 2014-08-22 21:46:46
Message-ID: alpine.LNX.2.11.1408221439440.2751@localhost
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

One column in a table has values for the attribute 'stream'. Some queries
return some rows where a stream name (only identified one so far) has an
appended '+'. I cannot update the table to remove that appended character,
and I've not seen this before.

Example:

2220 | STV | 2012-07-12 | Nematoda | | |
| | Omnivore | 50 | | StarvationCrk+| Owyhee
| | | | | |
| | | | | |
2701 | STV-10 | 2013-07-10 | Nematoda | | |
| | Omnivore | 36 | | StarvationCrk | Owyhee

I'd appreciate learning where that '+' originates and how to get rid of
it. A query to count the rows with the appendage returns zero:

select count(*) from benthos where stream = 'StarvationCrk';
count
-------
204

select count(*) from benthos where stream = 'StarvationCrk+';
count
-------
0

TIA,

Rich

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2014-08-22 21:52:58 Re: ERROR: Problem running post install step
Previous Message Joseph Kregloh 2014-08-22 19:51:51 Re: Restart replicated slave procedure