sorting of a price field

Поиск
Список
Период
Сортировка
От Anne Wainwright
Тема sorting of a price field
Дата
Msg-id 20130914120758.GA30897@fables.co.za
обсуждение исходный текст
Ответы Re: sorting of a price field  (Jay Riddle <jcriddle4@yahoo.com>)
Re: sorting of a price field  (Thomas Kellerer <spam_eater@gmx.net>)
Re: sorting of a price field  (Jov <amutu@amutu.com>)
Re: sorting of a price field  (vinayak <vinpokale@gmail.com>)
Список pgsql-novice
Hi,

I run a fairly simple query to show current records of stock using the
phrase 'sort by shop_price'.

Surprise (but really no surprise) this is sorted in ascii order rather
than shop_price order. So 110.00 comes before 20.00

I can't see any reference to changing this. What can I do, is this
perhaps to do with the field type, can it be changed?

Thanks
Anne


В списке pgsql-novice по дате отправления:

Предыдущее
От: DFE
Дата:
Сообщение: Re: PostgreSQL 9.3 Error when trying to run Create Extension postgis
Следующее
От: Kartik Vashishta
Дата:
Сообщение: undefined symbol: boot_DynaLoader