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

From Ennio-Sr
Subject Re: order by question.
Date
Msg-id 20070504234335.GA18016@deby.ei.hnet
Whole thread Raw
In response to Re: order by question.  (Ennio-Sr <nasr.laili@tin.it>)
List pgsql-bugs
* Ennio-Sr <nasr.laili@tin.it> [040507, 23:52]:
> * 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;
> >
> 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;
>        ^^^^^^^^^^^^^^^^^^^^

Oops ... I missed your "order by 2" ... Sorry ;(

--
[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: Stephan Szabo
Date:
Subject: Re: order by question.
Next
From: Russell Smith
Date:
Subject: Re: Removing pg_auth_members.grantor (was Grantor name gets lost when grantor role dropped)