Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Thank you guys! That was the point.


--- hubert depesz lubaczewski <depesz@xxxxxxxxxx> schrieb am So, 15.8.2010:

> Von: hubert depesz lubaczewski <depesz@xxxxxxxxxx>
> Betreff: Re:  Wrong "ORDER BY" on a numeric value result
> An: "Stefan Wild" <wilds81@xxxxxxxx>
> CC: pgsql-general@xxxxxxxxxxxxxx
> Datum: Sonntag, 15. August, 2010 05:53 Uhr
> On Sat, Aug 14, 2010 at 09:46:37PM
> +0000, Stefan Wild wrote:
> > Hello guys,
> > 
> > I have following sorting problem and need your help.
> When executing this SELECT statement:
> > 
> > "SELECT           
>       d.id,         
>         d.name,
> > d.description,     
>    ts.name,         
>      d.opentimestamp,
> > d.initialvalue,       
> d.plmoney,         
>    d.performance,
> > d.performancepa,   
>    d.currentopenmoney,   
> d.investedmoney,
> > d.investedpercent, 
>    d.cashmoney,       
>    d.realizedwinmoney,
> >
> d.realizedlossmoney,   d.currenttotalvalue,   d.depotriskpercent,
> > d.taxesratepercent,    d.taxallowance, 
>       d.paidtaxes,
> > d.paidfees         
>    FROM c_depots d INNER JOIN
> c_tradingsystems ts
> > ON d.tradingsystem_id=ts.id INNER JOIN cx_users_depots
> cx ON
> > cx.id_depots=d.id INNER JOIN c_users u ON
> cx.id_users=u.id WHERE
> > u.login='xxxx' ORDER BY UPPER(CAST
> (d.currenttotalvalue AS numeric) )
> > DESC"
> > The column currenttotalvalue has a numeric type with a
> length of 14 and 2 digits for percision. The initial SELECT
> didn't used the CAST, but the result was also wrong.
> 
> 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.
> 
> depesz
> 
> -- 
> Linkedin: http://www.linkedin.com/in/depesz ;
> /  blog: http://www.depesz.com/
> jid/gtalk: depesz@xxxxxxxxxx
> / aim:depeszhdl / skype:depesz_hdl / gg:6749007
> 




-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux