Re:
| От | Zuoxin.Wang@kp.org |
|---|---|
| Тема | Re: |
| Дата | |
| Msg-id | OF62753886.12AE3108-ON88256FE8.00741610@KP.ORG обсуждение исходный текст |
| Ответ на | (Zuoxin.Wang@kp.org) |
| Список | pgsql-admin |
Thanks Alvaro, you are right. Appreciate your quick help.
Jason
| Alvaro Herrera <alvherre@dcc.uchile.cl> 04/19/2005 01:46 PM | 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=# 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[@]dcc.uchile.cl>)
"La conclusión que podemos sacar de esos estudios es que
no podemos sacar ninguna conclusión de ellos" (Tanenbaum)
В списке pgsql-admin по дате отправления: