Re: Appended '+' in Column Value - Mailing list pgsql-general

From Adrian Klaver
Subject Re: Appended '+' in Column Value
Date
Msg-id 53F7C102.9000305@aklaver.com
Whole thread Raw
In response to Re: Appended '+' in Column Value  (Rich Shepard <rshepard@appl-ecosys.com>)
Responses Re: Appended '+' in Column Value  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
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


pgsql-general by date:

Previous
From: Rich Shepard
Date:
Subject: Re: Appended '+' in Column Value
Next
From: Tom Lane
Date:
Subject: Re: Appended '+' in Column Value