Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 2C82B2E02B3 for ; Fri, 7 Mar 2008 09:23:51 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 50989-05 for ; Fri, 7 Mar 2008 09:23:48 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from ug-out-1314.google.com (ug-out-1314.google.com [66.249.92.173]) by postgresql.org (Postfix) with ESMTP id AC6382E01F2 for ; Fri, 7 Mar 2008 09:23:48 -0400 (AST) Received: by ug-out-1314.google.com with SMTP id j3so3748591ugf.49 for ; Fri, 07 Mar 2008 05:23:47 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; bh=wTPANg+OI3B6z+jgjupfk7dgVdOTD613MfUKi9nmJtU=; b=ZubHzwLsBBIguQ2x6SCkQGGt+8B8BCLTQOlg1MVioCCjX5EdZX02Vr+w7jt8l+InTvou84VmkU9Nb+S7foSWujyWBi35XbsQ/s7qzbYGwwIZoseogwRaZspoOLtganudLzMI8DnO2M028JuNh4ORELyCJm3ych4PkHvulmKfzn0= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=mXGbRawef7te8xCgXY8juYMiU6EAr5E0xAw4WUlEFluAhHok94PgL2Jc/zCoRtRfnW0fbTrdzo/h+isU7wu6ia586lrqvEzPljTz6TBlhMYYzlqcPT3ZuLTEAvD2e/GOUEQJDN/xbZYrQ5Z1kuHric/CDq0jFThK8zWos6GOohw= Received: by 10.78.140.17 with SMTP id n17mr3687842hud.43.1204896216351; Fri, 07 Mar 2008 05:23:36 -0800 (PST) Received: by 10.78.202.12 with HTTP; Fri, 7 Mar 2008 05:23:36 -0800 (PST) Message-ID: <3b6c69d80803070523rc2dff99rf7f3d6de8d83729c@mail.gmail.com> Date: Fri, 7 Mar 2008 16:23:36 +0300 From: "Yura Gal" To: "Tom Lane" Subject: Re: RETURN QUERY generates error Cc: "Richard Huxton" , pgsql-sql@postgresql.org In-Reply-To: <19149.1204827255@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <3b6c69d80803052345g31af3b74k6b8878c65197d621@mail.gmail.com> <47CFAA53.7010309@archonet.com> <19149.1204827255@sss.pgh.pa.us> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200803/41 X-Sequence-Number: 30369 > The error sounds suspiciously like what would happen if you tried to > use RETURN QUERY in a pre-8.3 version. > > regards, tom lane > Thanks a lot to all. Actually there were a mass of errors in my function. Now I rewrite it so as it works. It would be much more complicated to achieve my goal without your advices.