Received: from localhost (uranus.hub.org [200.46.204.60]) by postgresql.org (Postfix) with ESMTP id 1F9E79FA12B for ; Mon, 13 Nov 2006 13:34:19 -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 09249-10 for ; Mon, 13 Nov 2006 13:34:17 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from mail.zanthus.com.br (mail.zanthus.com.br [200.212.65.85]) by postgresql.org (Postfix) with ESMTP id D92889FA0B9 for ; Mon, 13 Nov 2006 13:34:16 -0400 (AST) Received: from cprsakai (unknown [192.168.0.71]) (using TLSv1 with cipher RC4-MD5 (128/128 bits)) (No client certificate requested) by mail.zanthus.com.br (Postfix) with ESMTP id 32F1F23FBB for ; Mon, 13 Nov 2006 15:39:30 -0200 (BRST) Reply-To: From: "Rodrigo Sakai" To: Subject: Another question about composite types Date: Mon, 13 Nov 2006 15:33:40 -0300 Organization: Zanthus Message-ID: <000101c70752$3de4b560$4700a8c0@TREEZANTHUS> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0002_01C70739.18977D60" X-Mailer: Microsoft Office Outlook 11 Thread-Index: AccHUj1v+vg5yyDcTU+QSsn5I3W44w== X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1807 X-Zanthus-MailScanner: Found to be clean X-Zanthus-MailScanner-From: rodrigo.sakai@zanthus.com.br X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200611/135 X-Sequence-Number: 26787 This is a multi-part message in MIME format. ------=_NextPart_000_0002_01C70739.18977D60 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Hi, I need to create a table like: 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 ? Thanks! ------=_NextPart_000_0002_01C70739.18977D60 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

  Hi, I need to create a table = like:

 

  = 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 ?

 

 

 Thanks!

------=_NextPart_000_0002_01C70739.18977D60--