Re: Appended '+' in Column Value

On 14/08/23 6:46, 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.
>
>   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

You have a newline character. Try:

  select count(*) from benthos where stream = E'StarvationCrk\n';

Regards

Ian Barwick

--
 Ian Barwick                   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services