From: | Anne Wainwright <anotheranne(at)fables(dot)co(dot)za> |
---|---|
To: | Jov <amutu(at)amutu(dot)com> |
Cc: | pgsql-novice <pgsql-novice(at)postgresql(dot)org> |
Subject: | Re: sorting of a price field |
Date: | 2013-09-15 12:25:24 |
Message-ID: | 20130915122524.GA6083@fables.co.za |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
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(at)fables(dot)co(dot)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(at)postgresql(dot)org)
> > To make changes to your subscription:
> > http://www.postgresql.org/mailpref/pgsql-novice
> >
From | Date | Subject | |
---|---|---|---|
Next Message | Ishaya Bhatt | 2013-09-15 13:26:12 | Hot Deploy in PostGres |
Previous Message | Jay Riddle | 2013-09-14 14:54:27 | Re: sorting of a price field |