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

Re:

From: Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl>
To: Zuoxin(dot)Wang(at)kp(dot)org
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re:
Date: 2005-04-19 20:46:14
Message-ID: 20050419204614.GA32143@dcc.uchile.cl (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 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)

In response to

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

Responses

  • Re: at 2005-04-19 21:08:44 from Steve Crawford

pgsql-admin by date

Next:From: Scott MarloweDate: 2005-04-19 20:48:01
Subject: Re:
Previous:From: Bruno Wolff IIIDate: 2005-04-19 20:37:27
Subject: Re: brute force attacking the password

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