Re: order by question.

From: Ennio-Sr <nasr(dot)laili(at)tin(dot)it>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Re: order by question.
Date: 2007-05-04 21:52:18
Message-ID: 20070504215218.GA17012@deby.ei.hnet
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

* Jose Blanco <blancoj(at)umich(dot)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) ]

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Stephen Frost 2007-05-04 21:54:50 Re: Removing pg_auth_members.grantor (was Grantor name gets lost when grantor role dropped)
Previous Message Tom Lane 2007-05-04 21:31:50 Re: Removing pg_auth_members.grantor (was Grantor name gets lost when grantor role dropped)