Re: ORDER BY in SQL functions - Mailing list pgsql-sql

"K. Ari Krupnikov" <ari@iln.net> writes:
> CREATE FUNCTION foo (INT)
> RETURNS SETOF INT AS '
>     SELECT id
>     FROM   table
>     WHERE  some_colunm > $1
>     ORDER BY some_other_colunm
> ' LANGUAGE 'sql';

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

This is a bug in the SQL-function support --- the check for correct
return type gets confused by the extra hidden column used for the
ORDER BY.  It'll work if you ORDER BY the column you're returning,
not that that helps you much.

It's fixed in 7.1.
        regards, tom lane