X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id CB4FC52C84 for ; Mon, 18 Jul 2005 04:48:36 -0300 (ADT) 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 15872-09 for ; Mon, 18 Jul 2005 07:48:32 +0000 (GMT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by svr1.postgresql.org (Postfix) with ESMTP id A6FC752BC6 for ; Mon, 18 Jul 2005 04:48:32 -0300 (ADT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by news.hub.org (8.13.1/8.13.1) with ESMTP id j6I7mVYl026639 for ; Mon, 18 Jul 2005 07:48:32 GMT (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.13.1/8.13.1/Submit) id j6I7ML0T016642 for pgsql-admin@postgresql.org; Mon, 18 Jul 2005 07:22:21 GMT (envelope-from news) From: Ezequiel Tolnay X-Newsgroups: pgsql.admin Subject: Re: functions vs stored procedures Date: Mon, 18 Jul 2005 17:23:55 +1000 Organization: Hub.Org Networking Services Lines: 17 Message-ID: <42DB590B.2040203@etolnay.com.ar> References: <14063.1121347025@sss.pgh.pa.us> <20050715131641.GA26236@alvh.no-ip.org> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Complaints-To: usenet@news.hub.org To: Alvaro Herrera User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.7.6) Gecko/20050319 X-Accept-Language: en-au, en-gb, en-us, en, es-ar, es-es In-Reply-To: <20050715131641.GA26236@alvh.no-ip.org> To: pgsql-admin@postgresql.org X-Virus-Scanned: by amavisd-new at hub.org X-Archive-Number: 200507/187 X-Sequence-Number: 18243 Alvaro Herrera wrote: > Wow, incredible. You misread the whole documentation. I certainly did, I read it with more care this time. It is a great solution when we're required to return a single record with a custom type, which are few but there certainly are. I wonder if you know any tricks to do something similar but returning rowsets instead of a single record? I'm currently doing some tests with cursor references, which I've been sugested on another thread. Thanks for your help, and sorry for not paying the appropriate attention to your previous hint ;) Regards, Ezequiel Tolnay