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 843C752B06 for ; Fri, 15 Jul 2005 10:16:38 -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 42202-07 for ; Fri, 15 Jul 2005 13:16:33 +0000 (GMT) Received: from mr2.surnet.cl (smtp2.surnet.cl [216.155.73.163]) by svr1.postgresql.org (Postfix) with ESMTP id 5943F52B5B for ; Fri, 15 Jul 2005 10:16:32 -0300 (ADT) Received: from smtp2.surnet.cl (216.155.73.169) by mr2.surnet.cl (7.0.031.3) id 4259ADFA015B7E8C; Fri, 15 Jul 2005 09:16:15 -0400 Received: from smtp1.surnet.cl (smtp1.surnet.cl []) by mr2.surnet.cl ([216.155.73.169]); Fri, 15 Jul 2005 13:16:14 +0000 Received: from cluster.surnet.cl (216.155.73.164) by smtp1.surnet.cl (7.0.031.3) id 42587C6E01098FE3; Fri, 15 Jul 2005 09:15:54 -0400 Received: from alvh.no-ip.org (200.85.218.66) by cluster.surnet.cl (7.0.043) (authenticated as alvherre@surnet.cl) id 42B3EF60003DE795; Fri, 15 Jul 2005 09:16:31 -0400 Received: by alvh.no-ip.org (Postfix, from userid 1000) id D5D5FC370EE; Fri, 15 Jul 2005 09:16:41 -0400 (CLT) Date: Fri, 15 Jul 2005 09:16:41 -0400 From: Alvaro Herrera To: Ezequiel Tolnay Cc: pgsql-admin@postgresql.org Subject: Re: functions vs stored procedures Message-ID: <20050715131641.GA26236@alvh.no-ip.org> References: <14063.1121347025@sss.pgh.pa.us> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.5.9i X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=1.384 tagged_above=0 required=5 tests=AWL, DNS_FROM_RFC_ABUSE, FORGED_RCVD_HELO, RCVD_IN_NJABL_PROXY X-Spam-Level: * X-Archive-Number: 200507/110 X-Sequence-Number: 18166 On Fri, Jul 15, 2005 at 10:57:04AM +1000, Ezequiel Tolnay wrote: > Thanks for the tip, but unfortunately id didn't address any of my > concerns. I alreay use the version 8, and I'm aware of the possibility > of using arrays for the results, which allows for some flexibility. But > unfortunately arrays are not records, and I'm limited to values of the > same types, and cannot refer the values from their column names. To > create this function I also have to build the arrays for each result, > casting all the values to text in a way that I would be able to convert > back to the original value. Wow, incredible. You misread the whole documentation. -- Alvaro Herrera () "We are who we choose to be", sang the goldfinch when the sun is high (Sandman)