X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 69B5ED9E58 for ; Wed, 9 Nov 2005 14:49:45 -0400 (AST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 27551-07 for ; Wed, 9 Nov 2005 18:49:43 +0000 (GMT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id 71D60D9DE0 for ; Wed, 9 Nov 2005 14:49:43 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.1/8.13.1) with ESMTP id jA9InfCI018101; Wed, 9 Nov 2005 13:49:41 -0500 (EST) To: mario.splivalo@mobart.hr Cc: pgsql-sql@postgresql.org Subject: Re: RETURNS SETOF table; language 'sql' In-reply-to: <1131549050.7758.11.camel@ekim> References: <1131549050.7758.11.camel@ekim> Comments: In-reply-to Mario Splivalo message dated "Wed, 09 Nov 2005 16:10:50 +0100" Date: Wed, 09 Nov 2005 13:49:41 -0500 Message-ID: <18100.1131562181@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.006 required=5 tests=[AWL=0.006] X-Spam-Score: 0.006 X-Spam-Level: X-Archive-Number: 200511/79 X-Sequence-Number: 23330 Mario Splivalo writes: > When I do: > SELECT * FROM get_ads(1004); > i get: > ERROR: query-specified return row and actual function return row do not > match The example as given works fine for me in 7.4.9. Maybe you need an update, or maybe you're not telling us the whole truth about what you did. regards, tom lane