Re:

Thanks Alvaro, you are right. Appreciate your quick help.

Jason

Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl>
04/19/2005 01:46 PM

To: Zuoxin Wang/CA/KAIPERM(at)Kaiperm
cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: [ADMIN]

On Tue, Apr 19, 2005 at 01:27:09PM -0700, Zuoxin(dot)Wang(at)kp(dot)org wrote:

> test=# select used from patient;
> used
> ------
> N
> N
> (2 rows)

Try

select '{' || used || '}' from patient;

> 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)

Looks like you have some non-printable character in the used column.

--
Alvaro Herrera (<alvherre[(at)]dcc(dot)uchile(dot)cl>)
"La conclusión que podemos sacar de esos estudios es que
no podemos sacar ninguna conclusión de ellos" (Tanenbaum)