Re: [SQL] Order by in stored functions

2000-09-04 Thread Tom Lane
Andreas Tille <[EMAIL PROTECTED]> writes: > I've got the following error message: > ERROR: function declared to return varchar returns multiple values in > final retrieve This is a bug that has already been fixed in current sources: the check that makes sure your select produces only one varchar

[SQL] Order by in stored functions

2000-09-03 Thread Andreas Tille
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 t