Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id 7A40F9FA12B for ; Mon, 13 Nov 2006 13:46:17 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024) with ESMTP id 29904-07 for ; Mon, 13 Nov 2006 17:46:10 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from web31811.mail.mud.yahoo.com (web31811.mail.mud.yahoo.com [68.142.207.74]) by postgresql.org (Postfix) with SMTP id CE0009F9F0A for ; Mon, 13 Nov 2006 13:46:09 -0400 (AST) Received: (qmail 72616 invoked by uid 60001); 13 Nov 2006 17:46:05 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:Date:From:Subject:To:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding:Message-ID; b=NUOyWU1IVa5CZ6SFg7w3MgG+TOTTp4M3pEW7/1copfwhDdaoWxVLbbrjD+AhQNIJt+SrQPM2oFus5c8CqP/ukiEDSin1a1XSMDHylb5VPLeqLfIyjKbLmPoeNqJ/ETeQsi0s7fVaflHZiN+exu7rtlQgBOF5PLXHUtsAiK+72QI= ; X-YMail-OSG: X3MK5REVM1lOQqm..fm.kAy4g13Mkbt7I1Injdma Received: from [12.177.97.50] by web31811.mail.mud.yahoo.com via HTTP; Mon, 13 Nov 2006 09:46:05 PST Date: Mon, 13 Nov 2006 09:46:05 -0800 (PST) From: Richard Broersma Jr Subject: Re: Another question about composite types To: rodrigo.sakai@zanthus.com.br, pgsql-sql@postgresql.org In-Reply-To: <000101c70752$3de4b560$4700a8c0@TREEZANTHUS> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Message-ID: <277719.72609.qm@web31811.mail.mud.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.756 tagged_above=0 required=5 tests=BAYES_00, DNS_FROM_RFC_ABUSE, DNS_FROM_RFC_POST, DNS_FROM_RFC_WHOIS X-Spam-Level: X-Archive-Number: 200611/138 X-Sequence-Number: 26790 > CREATE TYPE t_salary AS (Value numeric(10,2), Validity date); > CREATE TABLE employee (id int, name varchar(30), salary t_salary[]); > > That is, I need an array of composite type and searching on google I found > that is impossible to do it! Is it really impossible? Anyone have do it ? Why not use a conventional table to hold this information that references your employee table? Regards, Richard Broersma Jr.