X-Original-To: pgsql-advocacy-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 1E227D1B356 for ; Thu, 3 Jun 2004 20:10:15 -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 10977-08 for ; Thu, 3 Jun 2004 23:10:16 +0000 (GMT) Received: from davinci.ethosmedia.com (server228.ethosmedia.com [209.128.84.228]) by svr1.postgresql.org (Postfix) with ESMTP id 93B4ED1B344 for ; Thu, 3 Jun 2004 20:10:12 -0300 (ADT) Received: from [63.195.55.98] (HELO spooky) by davinci.ethosmedia.com (CommuniGate Pro SMTP 4.1.8) with ESMTP id 5266562; Thu, 03 Jun 2004 16:11:50 -0700 Content-Type: text/plain; charset="iso-8859-1" From: Josh Berkus Organization: Aglio Database Solutions To: elein Subject: Re: [SQL] SQL Spec Compliance Questions Date: Thu, 3 Jun 2004 16:09:51 -0700 User-Agent: KMail/1.4.3 Cc: postgresql advocacy References: <200403302050.12415.josh@agliodbs.com> <20040603184526.GK32598@nibiru.metux.de> <20040603134144.X11485@cookie.varlena.com> In-Reply-To: <20040603134144.X11485@cookie.varlena.com> MIME-Version: 1.0 Content-Transfer-Encoding: 8bit Message-Id: <200406031609.51415.josh@agliodbs.com> X-Virus-Scanned: by amavisd-new at hub.org X-Archive-Number: 200406/47 X-Sequence-Number: 4470 Elein, > A typed table is an type which happens to be > a table. They are also known as composite types > or row types. Well, Tom was working on this for spec compliance. I don't know if he completed it. Of course, it doesn't answer the two corrolary questions: 1) Why would one want a typed table? 2) Aren't typed tables a big violation of relational database design? -- Josh Berkus Aglio Database Solutions San Francisco