Tom Lane wrote:
>
> "K. Ari Krupnikov" <[EMAIL PROTECTED]> 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 in
"K. Ari Krupnikov" <[EMAIL PROTECTED]> 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 r
Are ORDER BYs allowed in SQL functions? Or do SQL functions work like
views that are as unordered as their underlting tables?
CREATE FUNCTION foo (INT)
RETURNS SETOF INT AS '
SELECT id
FROM table
WHERE some_colunm > $1
' LANGUAGE 'sql';
works. But if I try
CREATE FUNCTION foo (IN
