Re: Appended '+' in Column Value

On 08/22/2014 03:03 PM, Rich Shepard wrote:
> On Sat, 23 Aug 2014, Ian Barwick wrote:
>
>> You have a newline character. Try:
>>  select count(*) from benthos where stream = E'StarvationCrk\n';
>
> Ian,
>
>    Interesting; that query returned 202 of 204 rows.

Yeah, means either whoever inputted the data kept hitting Enter after
each string(most of the time) or whatever program input the data added \n.

>
> Thanks,
>
> Rich
>
>


--
Adrian Klaver
adrian.klaver@aklaver.com