Re: UPDATE table: Syntax to Remove Terminal '\n' [RESOLVED]

Rich Shepard <rshepard@xxxxxxxxxxxxxxx> · Wed, 27 Aug 2014 16:13:24 -0700 (PDT)

On Wed, 27 Aug 2014, Jeff Ross wrote:

You want the E in front of the entire string, not just before the \n.
select
'Use Discover: ' || E'\t' || 'Yes'  || E'\n'

Jeff,

  That did the trick. Turns out that 202 of 204 rows had the newline! The
syntax that worked:

update benthos set stream = 'StarvationCrk' where stream = E'StarvationCrk\n';

Much appreciated,

Rich

--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general