SELECT DISTINCT a ORDER BY v PgSQL

["Zíka Aleš, Ing."]

	Dobry den!

	PostgreSQL 7.4.3 mi odmita akceptovat dotaz:

SELECT DISTINCT polozka, nazev FROM menu ORDER BY polozka::text;
ERROR:  For SELECT DISTINCT, ORDER BY expressions must appear in target list

Netusim proc ma tuhle podminku, ale to je asi jedno. Da se to obejit takhle:

SELECT * FROM (SELECT DISTINCT polozka, nazev FROM menu) AS menu ORDER BY
polozka::text;

ale neprijde mi to prilis elegantni.

	Nevite o nejakem lepsim reseni?


	Díky,
			Ales Zika
			CSE Spoje Pelhrimov

			http://results.cz
			e-mail: Ales.Zika na pel.br.ds.mfcr.cz
				  Ales.Zika na seznam.cz