From: tjk@tksoft.com <tjk@tksoft.com>
To: morrisonjeffrey@hotmail.com
Cc: pgsql-sql@postgresql.org
Subject: Re: SQL specified sort
Date: Mon, 28 May 2001 06:29:15 -0700 (PDT)
Message-ID: <200105281329.GAA11700@smtp3.tksoft.com> (raw)
In-Reply-To: <F51hKLcMdsokDAtTLnX00019a19@hotmail.com>
Jeff,
If you want to receive your data in an order which
you specify manually, the easiest way to accomplish this
is to add a separate field which contains an int4 value
used by you to specify the order.
E.g.
myval | sortint
_____________________
H29 | 2
214 | 1
200 | 3
099 | 4
SELECT myval FROM mytable ORDER BY sortint;
Troy
>
> I was wondering if you could help me out with a problem I'm having. Say for
> example I have data coming out like:
> H29
> 214
> 200
> 099
>
> How would I use a sort to be able to make the output look like
>
> 214
> H29
> 200
> 099
>
> I don't believe their is a way to do an ORDER BY in a specific order. Any
> help you could give me this problem would be very much appreciated.
>
> Jeff Morrison
> _________________________________________________________________________
> Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>
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: tjk@tksoft.com, morrisonjeffrey@hotmail.com
Subject: Re: SQL specified sort
In-Reply-To: <200105281329.GAA11700@smtp3.tksoft.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