On 08/22/2014 02:46 PM, Rich Shepard wrote:
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.
Is this only in psql?
If so I would suspect the table formatting code.
What happens if you do \x and then look at the records?
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
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
