X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 689CE53A11 for ; Tue, 19 Apr 2005 18:14:30 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 22561-01 for ; Tue, 19 Apr 2005 21:14:23 +0000 (GMT) Received: from mail.kp.org (ktazp5001.kp.org [162.119.241.43]) by svr1.postgresql.org (Postfix) with ESMTP id 1C4D353A01 for ; Tue, 19 Apr 2005 18:14:22 -0300 (ADT) Received: from ktazp598.kp.org ([172.21.128.151]) by mail.kp.org with ESMTP id j3JKpvq6020597 for ; Tue, 19 Apr 2005 17:09:17 -0400 (EDT) Received: from cscrdngat001.crdc.KP.ORG by ktazp598 with ESMTP; Tue, 19 Apr 2005 14:09:06 -0700 To: alvherre@dcc.uchile.cl Cc: pgsql-admin@postgresql.org Subject: Re: MIME-Version: 1.0 X-Mailer: Lotus Notes Release 5.0.8 June 18, 2001 Message-Id: From: Zuoxin.Wang@kp.org Date: Tue, 19 Apr 2005 14:09:04 -0700 X-MIMETrack: Serialize by Router on CRDC-GWY01/GSVR/KAIPERM(Release 5.0.11 |July 24, 2002) at 04/19/2005 02:11:05 PM, Serialize complete at 04/19/2005 02:11:05 PM Content-Type: multipart/alternative; boundary="=_alternative 00742FFC88256FE8_=" X-KP: PPSAV - [172.21.128.151] - 2005-04-19 - 17:09:18 X-Proofpoint-Spam-Score: : 0 X-Spam-Details: rule=notspam score=0 mlx=-1 adultscore=0 adjust=0 version=2.1.0-05041800 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.591 tagged_above=0 required=5 tests=AWL, DNS_FROM_RFC_ABUSE, HTML_50_60, HTML_MESSAGE, NO_REAL_NAME X-Spam-Level: X-Archive-Number: 200504/281 X-Sequence-Number: 17294 This is a multipart message in MIME format. --=_alternative 00742FFC88256FE8_= Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Thanks Alvaro, you are right. Appreciate your quick help. Jason Alvaro Herrera 04/19/2005 01:46 PM =20 To: Zuoxin Wang/CA/KAIPERM@Kaiperm cc: pgsql-admin@postgresql.org Subject: Re: [ADMIN] On Tue, Apr 19, 2005 at 01:27:09PM -0700, Zuoxin.Wang@kp.org wrote: > test=3D# select used from patient; > used > ------ > N > N > (2 rows) Try select '{' || used || '}' from patient; > test=3D# select first=5Fname, last=5Fname, used, birthday from patient; > first=5Fname | last=5Fname | used | birthday > ------------+-----------+------+------------ > | 1960-02-01DI | N > | 1960-02-01DI | N > (2 rows) Looks like you have some non-printable character in the used column. --=20 Alvaro Herrera () "La conclusi=F3n que podemos sacar de esos estudios es que no podemos sacar ninguna conclusi=F3n de ellos" (Tanenbaum) --=_alternative 00742FFC88256FE8_= Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Thanks Alvaro, you are right. Apprec= iate your quick help.


Jason





Alvaro Herrera <alvherre@dcc.u= chile.cl>

04/19/2005 01:46 PM

       
        To: &nbs= p;      Zuoxin Wang/CA/KAIPERM@Kaiperm
        cc: &nbs= p;      pgsql-admin@postgresql.org
        Subject:=        Re: [ADMIN]



On Tue, Apr 19, 2005 at 01:27:09PM = -0700, Zuoxin.Wang@kp.org wrote:

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

Try

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

> test=3D# select  first=5Fname, last=5Fname, used, birthday from p= atient;
>  first=5Fname | last=5Fname | 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[@]dcc.uchile.cl>)
"La conclusi=F3n que podemos sacar de esos estudios es que
no podemos sacar ninguna conclusi=F3n de ellos" (Tanenbaum)


--=_alternative 00742FFC88256FE8_=--