Adrian Klaver writes:
> 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';
> Yeah, means either whoever inputted the data kept hitting Enter after
> each
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 kep
On Fri, 22 Aug 2014, Adrian Klaver wrote:
Is this only in psql?
Adrian,
Yes.
Thanks,
Rich
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
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.
Thanks,
Rich
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make c
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
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 befor
On Fri, Aug 22, 2014 at 02:46:46PM -0700, 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
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
