Received: from mail.postgresql.org (webmail.postgresql.org [216.126.85.28]) by mail.postgresql.org (8.11.1/8.11.1) with SMTP id f1DDHNx75181 for ; Tue, 13 Feb 2001 08:17:23 -0500 (EST) (envelope-from pgsql-sql-owner@postgresql.org) Received: from lyn.iter.co.il (we-24-130-216-66.we.mediaone.net [24.130.216.66]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f1D3eax04331 for ; Mon, 12 Feb 2001 22:40:36 -0500 (EST) (envelope-from ari@iln.net) Received: from iln.net (IDENT:kostya@lyn.iter.co.il [127.0.0.1]) by lyn.iter.co.il (8.9.3/8.9.3) with ESMTP id TAA16038; Mon, 12 Feb 2001 19:36:04 -0500 Message-ID: <3A888174.E2410AC3@iln.net> Date: Mon, 12 Feb 2001 19:36:04 -0500 From: "K. Ari Krupnikov" Organization: iter.co.il X-Mailer: Mozilla 4.72 [en] (X11; U; Linux 2.2.14-5.0 i586) X-Accept-Language: en MIME-Version: 1.0 To: Tom Lane , pgsql-sql@postgresql.org Subject: Re: ORDER BY in SQL functions References: <3A84965D.44806521@iln.net> <21879.982012625@sss.pgh.pa.us> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200102/246 X-Sequence-Number: 1437 Tom Lane wrote: > > "K. Ari Krupnikov" 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. What if the function is declared to retun a complex type, can I then sort it? I it works, this function can be wrapped in another function that simply returns this single column. Also, why did I get this message after posting to comp.databases.postgresql.sql? Do articles in that group automatically get posted to the mailing list? > Subject: Stalled post to pgsql-sql > > Your message to pgsql-sql has been delayed > pending approval of the list owner for > the following reason(s): > > Non-Member Submission from "K. Ari Krupnikov" -- K. Ari Krupnikov DBDOM - bridging XML and relational databases http://www.iter.co.il