From: David B <davidb999@gmail.com>
To: pgsql-sql@postgresql.org
Subject: ORDER BY handling mixed integer and varchar values
Date: Mon, 16 May 2005 11:47:59 -0700
Message-ID: <c76ea21c050516114742818cfa@mail.gmail.com> (raw)
Hi All,
I have a tabe
Product_desc varchar(100)
Product_price integer
Product_cat varchar(100)
The problem…
We have categories such as:
Electronics
White Goods
1
2
5
15
25
etc
I have a query
Select product_desc, product_price, product_cat
Order by product_cat, product_price
And of course I get stuff ordered as I want it.
BUT… with many product categories being numeric based they come out in
wrong order '10 comes before 2" etc.
So I tried
Select product_desc, product_price, product_cat
Order by cast(product_cat as integer), product_price
And that worked for the numberic based categories.
I don't know of a query will be across alpha or numeric categories.
Is there any elegent query you folks can think of that combines the
two so I can one query that has alpha sorting on alpha categories and
numeric sorting on numeric values that are in the same column??
Tia.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: davidb999@gmail.com
Subject: Re: ORDER BY handling mixed integer and varchar values
In-Reply-To: <c76ea21c050516114742818cfa@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox