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 004CB528BD for ; Mon, 20 Jun 2005 20:36:49 -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 79987-01 for ; Mon, 20 Jun 2005 23:36:48 +0000 (GMT) Received: from tigger.fuhr.org (tigger.fuhr.org [63.214.45.158]) by svr1.postgresql.org (Postfix) with ESMTP id 42E4C528BB for ; Mon, 20 Jun 2005 20:36:48 -0300 (ADT) Received: from winnie.fuhr.org (winnie.fuhr.org [10.1.0.1]) by tigger.fuhr.org (8.13.3/8.13.3) with ESMTP id j5KNaj5V074589 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=OK); Mon, 20 Jun 2005 17:36:47 -0600 (MDT) (envelope-from mfuhr@winnie.fuhr.org) Received: from winnie.fuhr.org (localhost [127.0.0.1]) by winnie.fuhr.org (8.13.3/8.13.3) with ESMTP id j5KNai1f028014; Mon, 20 Jun 2005 17:36:44 -0600 (MDT) (envelope-from mfuhr@winnie.fuhr.org) Received: (from mfuhr@localhost) by winnie.fuhr.org (8.13.3/8.13.3/Submit) id j5KNaiHW028013; Mon, 20 Jun 2005 17:36:44 -0600 (MDT) (envelope-from mfuhr) Date: Mon, 20 Jun 2005 17:36:44 -0600 From: Michael Fuhr To: grupos Cc: pgsql-sql@postgresql.org Subject: Re: Array in plpgsql with composite type Message-ID: <20050620233644.GA27951@winnie.fuhr.org> References: <42B6EF58.8090007@carvalhaes.net> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <42B6EF58.8090007@carvalhaes.net> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.005 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200506/259 X-Sequence-Number: 21860 On Mon, Jun 20, 2005 at 01:31:20PM -0300, grupos wrote: > > 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... According to the "Arrays" section of the "Data Types" chapter in the documentation, arrays of composite types aren't supported. http://www.postgresql.org/docs/8.0/static/arrays.html What problem are you trying to solve? If you tell us more about what you're doing then maybe we can suggest ways to do it. One way might be to use a procedural language like PL/Perl, PL/Tcl, or PL/Python instead of PL/pgSQL. -- Michael Fuhr http://www.fuhr.org/~mfuhr/