Postgres Pro
Downloads
Home   >   mailing lists

Re: Wrong "ORDER BY" on a numeric value result - Mailing list pgsql-general

From Thomas Kellerer
Subject Re: Wrong "ORDER BY" on a numeric value result
Date
Msg-id i489be$6l3$1@dough.gmane.org
Whole thread Raw
In response to Re: Wrong "ORDER BY" on a numeric value result  (Stefan Wild <wilds81@yahoo.de>)
Responses Re: Wrong "ORDER BY" on a numeric value result
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Stefan Wild
Date:
Subject: Re: Wrong "ORDER BY" on a numeric value result
Next
From: Alban Hertroys
Date:
Subject: Re: InitDB: Bad system call