| 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: | 56F1284A-3267-41AC-A431-FF7FF6848E47@gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| 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.
Brent.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Daniel Staal | 2012-03-03 01:04:40 | Re: Restoring selected records from backup file |
| Previous Message | Tom Lane | 2012-03-02 20:17:09 | Re: Data In Tables Sometimes Have + |