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(dot)rudnick(at)t-online(dot)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
>
In response to
pgsql-hackers by date
| Next: | From: Christian Ullrich | Date: 2011-02-01 22:17:00 |
| Subject: Re: Authentication Enhancement Proposal |
| Previous: | From: Alban Hertroys | Date: 2011-02-01 21:32:52 |
| Subject: Re: Issues with generate_series using integer boundaries |