Re: SQL99 - Nested Tables

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: Darren Alcorn <dalcorn(at)gmail(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: SQL99 - Nested Tables
Date: 2005-07-07 16:52:44
Message-ID: 200507070952.45574.josh@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Darren,

> I was interested as to if there were plans to develop SQL99 nested
> tables. I know with AJAX(tm) starting to grow in popularity that the
> XML features of SQL2003 would prove useful for EnterpriseDB.

I realize that nested tables are in SQL99, but so is SQLJ and a few other
really dumb ideas. As Joe Celko (member of the SQL92 committee) put it, "we
were a committee, and a committee never met a feature it didn't like."

Can you make a use-case for nested tables? It would need to be a fairly
strong one, given that they basically violate the relational model. If what
you're really interested in is XML data support, then I'd suggest focusing on
that instead.

Of course, that's just my opinion.

--
Josh Berkus
Aglio Database Solutions
San Francisco

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Hans-Jürgen Schönig 2005-07-07 16:54:28 Re: A couple of patches for PostgreSQL 64bit support
Previous Message Stephen Frost 2005-07-07 16:40:51 Must be owner to truncate?