Received: from localhost (uranus.hub.org [200.46.204.60]) by postgresql.org (Postfix) with ESMTP id B13F59FA103 for ; Mon, 6 Nov 2006 15:18:53 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.60]) (amavisd-new, port 10024) with ESMTP id 32426-04 for ; Mon, 6 Nov 2006 15:18:51 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id BCE189FB1EB for ; Mon, 6 Nov 2006 15:18:51 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.6/8.13.6) with ESMTP id kA6JIjKR028809; Mon, 6 Nov 2006 14:18:48 -0500 (EST) To: "Jose" cc: pgsql-sql@postgresql.org Subject: Re: Composite Types In-reply-to: <001901c6fd25$cc2b60d0$f001a8c0@cf> References: <001901c6fd25$cc2b60d0$f001a8c0@cf> Comments: In-reply-to "Jose" message dated "Tue, 31 Oct 2006 16:50:20 -0300" Date: Mon, 06 Nov 2006 14:18:45 -0500 Message-ID: <28808.1162840725@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200611/76 X-Sequence-Number: 26728 "Jose" writes: > If I try use > select unidade_regiao.(estado_sigla) from unidades No, you should do select (unidade_regiao).estado_sigla from unidades regards, tom lane