Re: [SQL] ORDER BY in SQL functions

2001-02-13 Thread K. Ari Krupnikov
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

Re: [SQL] ORDER BY in SQL functions

2001-02-12 Thread Tom Lane
"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