Appended '+' in Column Value
| От | Rich Shepard |
|---|---|
| Тема | Appended '+' in Column Value |
| Дата | |
| Msg-id | alpine.LNX.2.11.1408221439440.2751@localhost обсуждение исходный текст |
| Ответы |
Re: Appended '+' in Column Value
Re: Appended '+' in Column Value Re: Appended '+' in Column Value |
| Список | 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
В списке pgsql-general по дате отправления: