| From: | Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com> |
|---|---|
| To: | Susan Cassidy <susan(dot)cassidy(at)decisionsciencescorp(dot)com> |
| Cc: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: way to custom sort column by fixed strings, then by field's content |
| Date: | 2014-02-03 20:22:40 |
| Message-ID: | 52EFFA90.5000309@gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 02/03/2014 12:01 PM, Susan Cassidy wrote:
CCing the list.
> This didn't sort the way I want. It ended up as:
> description | description
> -------------------+-------------
> 18 cm long wrench | Scene 1
> absolute root |
> blue screwdriver | Scene 1
> red toolbox | Scene 1
> root 3 | Scene 1
> root 4 | Scene 2
> root 6 | Scene 3
> small wrench | Scene 1
> tire | Scene 2
>
>
> The first column is the one I want sorted.
Probably best to show us a made up sample of what you want.
>
> Also note that I made it a left outer join\
Where?
>
> Susan
>
--
Adrian Klaver
adrian(dot)klaver(at)gmail(dot)com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Rob Sargent | 2014-02-03 20:26:10 | Re: way to custom sort column by fixed strings, then by field's content |
| Previous Message | Susan Cassidy | 2014-02-03 20:01:53 | Re: way to custom sort column by fixed strings, then by field's content |