Skip site navigation (1) Skip section navigation (2)

Re: Data In Tables Sometimes Have +

From: Brent Dombrowski <brent(dot)dombrowski(at)gmail(dot)com>
To: Carlos Mennens <carlos(dot)mennens(at)gmail(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Data In Tables Sometimes Have +
Date: 2012-03-02 22:34:47
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-novice
On Mar 2, 2012, at 11:40 AM, Carlos Mennens wrote:
> I've noticed as I interact with my database I use for customers, there
> are from time to time values that have a strange '+' character. For
> example:
> forge=# SELECT cust_id, cust_name, cust_contact, cust_email
> FROM customers
> WHERE cust_name Like 'Truth%';
>  cust_id   |     cust_name      | cust_contact  |     cust_email

I noticed that when I upgraded from 8.2 to 9.0. The 9.0 client (psql) was adding those in. I don't remember now what triggered it, but they are not in the actual data.


In response to

pgsql-novice by date

Next:From: Daniel StaalDate: 2012-03-03 01:04:40
Subject: Re: Restoring selected records from backup file
Previous:From: Tom LaneDate: 2012-03-02 20:17:09
Subject: Re: Data In Tables Sometimes Have +

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group