Message-ID: <4734B921.5050704@unipex.it>
Date: Fri, 09 Nov 2007 20:46:41 +0100
From: Michele Petrazzo - Unipex srl <michele.petrazzo@unipex.it>
User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US;
	rv:1.8.1b1) Gecko/20060724 Thunderbird/2.0a1 Mnenhy/0.7.4.0
MIME-Version: 1.0
To: Pgsql-Sql <pgsql-sql@postgresql.org>
Subject: functions are returns columns
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Hi all.
I want that a function return a table rows (like the doc says at 33.4.4.
SQL Functions as Table Sources), but I want the a function return only a
few cols, so the same that I select into the func.
Modifying the doc example:

CREATE TABLE foo (fooid int, foosubid int, fooname text);
INSERT INTO foo VALUES (1, 1, 'Joe');
INSERT INTO foo VALUES (1, 2, 'Ed');
INSERT INTO foo VALUES (2, 1, 'Mary');

CREATE FUNCTION getfoo(int) RETURNS foo AS $$
     SELECT fooid, foosubid FROM foo WHERE fooid = $1;
$$ LANGUAGE SQL;

This give me an error:

ERROR:  return type mismatch in function declared to return foo
DETAIL:  Final SELECT returns too few columns.
CONTEXT:  SQL function "getfoo"


So, how do it?

Thanks,
Michele