X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 718B55280D for ; Mon, 20 Jun 2005 13:32:54 -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 83518-10 for ; Mon, 20 Jun 2005 16:32:44 +0000 (GMT) Received: from nitrogenio.carvalhaes.net (unknown [200.175.206.50]) by svr1.postgresql.org (Postfix) with ESMTP id CF5E552806 for ; Mon, 20 Jun 2005 13:32:42 -0300 (ADT) Received: from [192.168.0.190] ([192.168.0.190]) (authenticated bits=0) by nitrogenio.carvalhaes.net (8.13.4/8.13.4) with ESMTP id j5KGLi89005599 for ; Mon, 20 Jun 2005 13:21:44 -0300 Message-ID: <42B6EF58.8090007@carvalhaes.net> Date: Mon, 20 Jun 2005 13:31:20 -0300 From: grupos User-Agent: Mozilla Thunderbird 1.0.2 (Windows/20050317) X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: Array in plpgsql with composite type Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Triade-MailScanner-Information: Por favor, entre em contato para obter detalhes X-Triade-MailScanner: Found to be clean X-MailScanner-From: grupos@carvalhaes.net X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.176 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200506/258 X-Sequence-Number: 21859 Hi Guys! I need to make an array with composite type (varchar, float8) to get data from a table (description and price) BUT I am having no success... I searched a lot on the internet without success. On the PostgreSQL manual there is no information how to handle array with plpgsql with composite types. I tried to create a type (varchar, float8) but without success... Can anyone send me some examples or references for arrays in plpgsql (I am using PostgreSQL 8.0.3). Regards, Rodrigo Carvalhaes -- Esta mensagem foi verificada pelo sistema de antivírus e acredita-se estar livre de perigo.