* Jose Blanco <[EMAIL PROTECTED]> [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) ] ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org