Re: order by question. - Mailing list pgsql-bugs

From Ennio-Sr
Subject Re: order by question.
Date
Msg-id 20070504215218.GA17012@deby.ei.hnet
Whole thread Raw
In response to Re: order by question.  ("Jose Blanco" <blancoj@umich.edu>)
Responses Re: order by question.  (Ennio-Sr <nasr.laili@tin.it>)
List pgsql-bugs
* Jose Blanco <blancoj@umich.edu> [040507, 14:28]:
> This second time I did, see
>
> select author, sort_author from itemsbyauthor where sort_author like 'tan%'
> order by 2;
>
>
> "order by 2"
>
> Or am I not understanding something?

Hi Jose,
have you tried to modify your query as others suggested? i.e.:

--> select author, sort_author from itemsbyauthor where sort_author like
'tan% ORDER BY sort_author;
      ^^^^^^^^^^^^^^^^^^^^
HTH
Regards,
    Ennio.

--
[Perche' usare Win$ozz (dico io) se ..."anche uno sciocco sa farlo.   \\?//
 Fa' qualche cosa di cui non sei capace!"  (diceva Henry Miller) ]    (°|°)
[Why use Win$ozz (I say) if ... "even a fool can do that.              )=(
 Do something you aren't good at!" (as Henry Miller used to say) ]

pgsql-bugs by date:

Previous
From: Stephen Frost
Date:
Subject: Re: Removing pg_auth_members.grantor (was Grantor name gets lost when grantor role dropped)
Next
From: Tom Lane
Date:
Subject: Re: Removing pg_auth_members.grantor (was Grantor name gets lost when grantor role dropped)