Order by in stored functions - Mailing list pgsql-sql

Hello

I tried to create the following function

CREATE Function pGetMenu ( int ) returns setof varchar As '   SELECT IdMenuShow || IdWebPage   FROM   Menu   WHERE
IdMenu= $1    ORDER BY IdSort ; ' language 'SQL' ;
 

I've got the following error message:

ERROR:  function declared to return varchar returns multiple values in final retrieve

If O just remove the ORDER BY clause als works well so I guess that the
ORDER BY has to be replaced by somethjing other.  Could somebody
enlighten me how to do the ordering in a stored procedure?

Kind regards
         Andreas.