X-Original-To: pgsql-advocacy-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 0E8A6D1EC7B; Fri, 2 Apr 2004 16:39:27 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 87015-03; Fri, 2 Apr 2004 12:39:30 -0400 (AST) Received: from davinci.ethosmedia.com (server228.ethosmedia.com [209.128.84.228]) by svr1.postgresql.org (Postfix) with ESMTP id 445C5D1EC52; Fri, 2 Apr 2004 12:39:24 -0400 (AST) Received: from [63.195.55.98] (HELO spooky) by davinci.ethosmedia.com (CommuniGate Pro SMTP 4.1.8) with ESMTP id 4754425; Fri, 02 Apr 2004 08:40:49 -0800 Content-Type: text/plain; charset="utf-8" From: Josh Berkus Organization: Aglio Database Solutions To: Joe Conway Subject: Re: SQL Spec Compliance Questions Date: Fri, 2 Apr 2004 08:38:22 -0800 User-Agent: KMail/1.4.3 Cc: pgsql-advocacy@postgresql.org, pgsql-sql@postgresql.org References: <200403302050.12415.josh@agliodbs.com> <406D1031.7010603@joeconway.com> In-Reply-To: <406D1031.7010603@joeconway.com> MIME-Version: 1.0 Content-Transfer-Encoding: 8bit Message-Id: <200404020838.22698.josh@agliodbs.com> X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200404/15 X-Sequence-Number: 3987 Joe, Thanks for your help! > 4.16.2 Referenceable tables, subtables, and supertables > A table BT whose row type is derived from a structured type ST is > called a typed table. Only a base table or a view can be a typed > table. A typed table has columns corresponding, in name and > declared type, to every attribute of ST and one other column REFC > that is the self-referencing column of BT; let REFCN be the > > I really don't quite understand this, but I don't think we have it ;-) Ye Gods and Little Fishes!! Was the SQL99 Committee smoking crack, or what? What the heck is that *for*? -- Josh Berkus Aglio Database Solutions San Francisco