Re: sorting of a price field

Thanks for what I hoped would be an easy solution. But this fails at
the onset of a check for the validity of the sql query. This is likely
to do with the CRUD front end that I am using (Kexi). I'll try this out
when I access pg directly.

So onto the next reply.

many thanks.
Anne


On Sat, Sep 14, 2013 at 08:19:01PM +0800, Jov wrote:
> what is the type of field？try order by shop_price::numeric.
> jov
> On Sep 14, 2013 8:06 PM, "Anne Wainwright" <anotheranne@fables.co.za> wrote:
>
> > 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
> >
> >
> > --
> > Sent via pgsql-novice mailing list (pgsql-novice@postgresql.org)
> > To make changes to your subscription:
> > http://www.postgresql.org/mailpref/pgsql-novice
> >