Re: Wrong "ORDER BY" on a numeric value result

From: Thomas Kellerer <spam_eater(at)gmx(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Wrong "ORDER BY" on a numeric value result
Date: 2010-08-15 08:43:27
Message-ID: i489be$6l3$1@dough.gmane.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Stefan Wild wrote on 15.08.2010 10:36:
>> column is numeric, but upper() works on text, and returns
>> text, so your
>> numeric column got casted to text by using upper (which is
>> pointless
>> anyway - there is no "upper" version of digits).
>> remove upper() and you'll be fine.
>>

> Thank you guys! That was the point.

The real question is:

what did you try to accomplish with the UPPER() on a numeric column?

Regards
Thomas

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alban Hertroys 2010-08-15 09:09:11 Re: InitDB: Bad system call
Previous Message Stefan Wild 2010-08-15 08:36:51 Re: Wrong "ORDER BY" on a numeric value result