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

Re:

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: Zuoxin(dot)Wang(at)kp(dot)org
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re:
Date: 2005-04-19 21:01:44
Message-ID: 20050419210144.GA82012@winnie.fuhr.org (view raw or flat)
Thread:
Lists: pgsql-admin
On Tue, Apr 19, 2005 at 01:27:09PM -0700, Zuoxin(dot)Wang(at)kp(dot)org wrote:
>
> test=# select  first_name, last_name, used, birthday from patient;
>  first_name | last_name | used |  birthday
> ------------+-----------+------+------------
>    | 1960-02-01DI       | N
>    | 1960-02-01DI       | N
> (2 rows)

I'd guess that the "used" columns contain carriage returns.  What
do you see if you run the following query?

SELECT replace(used, '\r', '\\r'), length(used) FROM patient;

-- 
Michael Fuhr
http://www.fuhr.org/~mfuhr/

In response to

  • at 2005-04-19 20:27:09 from Zuoxin.Wang

pgsql-admin by date

Next:From: Steve CrawfordDate: 2005-04-19 21:08:44
Subject: Re:
Previous:From: Zuoxin.WangDate: 2005-04-19 20:59:57
Subject: Missing value from PostgreSQL query?

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