| From: | Nick Rudnick <joerg(dot)rudnick(at)t-online(dot)de> |
|---|---|
| To: | Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov> |
| Cc: | Robert Haas <robertmhaas(at)gmail(dot)com>, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: [pgsql-general 2011-1-21:] Are there any projects interested in object functionality? (+ rule bases) |
| Date: | 2011-02-01 21:41:57 |
| Message-ID: | 4D487E25.5040100@t-online.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| 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(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
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Christian Ullrich | 2011-02-01 22:17:00 | Re: Authentication Enhancement Proposal |
| Previous Message | Alban Hertroys | 2011-02-01 21:32:52 | Re: Issues with generate_series using integer boundaries |