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: 56F1284A-3267-41AC-A431-FF7FF6848E47@gmail.com
Views: Raw Message | Whole Thread | 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.

In response to

Browse pgsql-novice by date

  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 +