Re: [pgsql-general 2011-1-21:] Are there any projects interested in object functionality? (+ rule bases)
Nick Rudnick <joerg.rudnick@t-online.de>
From: Nick Rudnick <joerg.rudnick@t-online.de>
To: Kevin Grittner <Kevin.Grittner@wicourts.gov>
Cc: Robert Haas <robertmhaas@gmail.com>, pgsql-hackers@postgresql.org
Date: 2011-02-01T21:41:57Z
Lists: pgsql-hackers
Hi Kevin, this example was for teaching AI students (with limited PostgreSQL knowledge) in a very basic lecture -- I did not want to tweak the SQL semantics too much; just demonstrate why SQL is rightfully called a 4GL language. ;-) Cheers, Nick On 02/01/2011 10:08 PM, Kevin Grittner wrote: > Nick Rudnick<joerg.rudnick@t-online.de> wrote: > >> here an inelegant example > > Based on that example, you should be sure to look at the INHERITS > clause of CREATE TABLE: > > http://www.postgresql.org/docs/current/interactive/sql-createtable.html > > PostgreSQL has the "is a" structure built in. That may not get you > all the way there, but between that and a few views, you might get > close without needing a lot of low level infrastructure work. > > -Kevin >