Received: from bjke.com (firewall-user@ganymede.bjke.com [144.210.8.38]) by hub.org (8.9.2/8.9.1) with ESMTP id RAA92675 for ; Wed, 24 Mar 1999 17:27:36 -0500 (EST) (envelope-from djackson@cpsgroup.com) Received: by bjke.com; id QAA06045; Wed, 24 Mar 1999 16:27:33 -0600 (CST) Received: from unknown(144.210.12.10) by gauntlet.bjke.com via smap (4.1) id xma005400; Wed, 24 Mar 99 16:26:35 -0600 Received: by cpsmail.cpsgroup.com with Internet Mail Service (5.5.2448.0) id ; Wed, 24 Mar 1999 16:27:11 -0600 Message-ID: From: "Jackson, DeJuan" To: Ingrith Andrea Correa Vargas , pgsql-sql@postgreSQL.org Subject: RE: [SQL] types and subtypes Date: Wed, 24 Mar 1999 16:27:02 -0600 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2448.0) Content-Type: text/plain; charset="iso-8859-1" > hello all! > > I want to simulate objects with Postgres and I would like to > know if it's > possible to create a type (like address: t_address) and then to create > another type (like customer) with an attribute of type t_address. Yes, you can. > And I have a second question: > Can I make a "reference" to an object of an existing type?! If what you mean here is a c-style typedef no not really but you can use inheritance. If what you mean is another name by which to refer to a table or row then the answer depend complete upon the context. In rules tables are already referenced as new, old, current. In pl/pgsql you can create references until your hearts content. > These are features provided by the SQL3 standar, I want to > know if it's > possible to implement it with Postgres. PostgreSQL isn't fully SQL3 compliant, but it's getting there. > Can somebody help to me?! That depends upon your problem, and you must remember that we are not psychiatrist, plastic-surgeons, or magicians but we'll do our best. > Thank you in advance, > //Ingrith Correa :) You're welcome in behind, -DEJ