From: Chris Travers [mailto:chris.travers@gmail.com]
Sent: 16 October 2012 22:37
To: Will Rutherdale (rutherw)
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Does Postgres Object-Relational Syntax follow Standard?
On Tue, Oct 16, 2012 at 2:00 PM, Will Rutherdale (rutherw) <rutherw@cisco.com> wrote:
Hi.
Not really. The one area the standard discusses in this area, namely single inheritance for structured data types, is
notsupported by PostgreSQL. As far as I can tell, the SQL 2003 standard followed more or less the approach Illustra
(whichbegan as a Pg fork but had a totally independent SQL implementation) but limited it to structured data types
onlyand thus avoided issues like jagged rows (which survive in Informix, but pose practical programming challenges and
thereforehave never been supported on PostgreSQL). The one area that is supported is CREATE TABLE foo OF TYPE bar; but
that'spretty anemic support if you ask me.
In my view, while there are rough edges, the PostgreSQL approach is richer than the SQL 2003 approach, and I suspect
thereason for the lack of SQL 2003 UNDER supertype support is that there hasn't been sufficient demand to justify
implementingit. This isn't a commonly used feature of Oracle or DB2.....
I would say that while there are some object-relational aspects to SQL 2003, the overlap between those and the
PostgreSQLmodel is non-existent for practical purposes. I have actually really come to like the PostgreSQL model.
Best Wishes,
Chris Travers
Thanks.
It sounds like Object-relational is decently supported by Postgres but there isn't much of a standard to follow.
Do you know whether there are any efficiency issues in Object-relational? For example, has anyone benchmarked whether
querieson an INHERITS table are more or less efficient than the equivalent using a JOIN and conventional table design?
-Will
