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
>