Re: order by question.

Поиск
Список
Период
Сортировка
От Ennio-Sr
Тема Re: order by question.
Дата
Msg-id 20070504234335.GA18016@deby.ei.hnet
обсуждение исходный текст
Ответ на Re: order by question.  (Ennio-Sr <nasr.laili@tin.it>)
Список 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 по дате отправления:

Предыдущее
От: Stephan Szabo
Дата:
Сообщение: Re: order by question.
Следующее
От: Russell Smith
Дата:
Сообщение: Re: Removing pg_auth_members.grantor (was Grantor name gets lost when grantor role dropped)