Error in SELECT clause with UPPER function

From: "Pascal Rempenault" <prempenault(at)hubwoo(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Error in SELECT clause with UPPER function
Date: 2002-11-12 11:54:12
Message-ID: NEBBIINNELNNLHDBPCCIMEAADLAA.prempenault@hubwoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

1) Using
PostgreSQL 7.2.3 on i586-pc-linux-gnu, compiled by GCC 2.95.3

2) Description

track=# select loginname, upper(loginname) from tperson;
loginname | upper
------------+------------
admin | ADMIN
prempena | PREMPENA
(2 rows)

track=# select loginname, upper(loginname) from tperson where
upper(loginname)='ADMIN';
loginname | upper
-----------+-------
(0 rows)

3) Expected result
loginname | upper
------------+------------
admin | ADMIN
(1 row)

If someone can help to understand why …

Thanks in advance.

Pascal

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Savita 2002-11-12 12:40:09 pgadmin II problem
Previous Message Andrew Sullivan 2002-11-12 11:35:02 Re: Upgrading from 7.1.3 to 7.2.3