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 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 It's probably an indication of a wrapped column value inside the display column bounded by |'s. Try fiddling with \x and \pset. Karsten -- GPG key ID E4071346 @ gpg-keyserver.de E167 67FD A291 2BEA 73BD 4537 78B9 A9F9 E407 1346 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
