| From: | Oliver Elphick <olly(at)lfix(dot)co(dot)uk> |
|---|---|
| To: | ajglist(at)izzy(dot)net |
| Cc: | Peter Childs <blue(dot)dragon(at)blueyonder(dot)co(dot)uk>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: History |
| Date: | 2003-02-02 12:00:38 |
| Message-ID: | 1044187238.32648.7.camel@linda.lfix.co.uk |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Sun, 2003-02-02 at 00:47, Alan Gutierrez wrote:
> One table for the lot. If you use inheritance, it is my understanding
> that it will be the same thing, since all the data will be stored in the
> base table. The only thing you'd remove is the table name.
Not so; inserts must go into a particular table in the hierarchy, and
rows are stored in the particular table to which they belong. However,
a SELECT further up the hierarchy will also report rows in the child
tables (though not columns added in the child tables) unless the keyword
ONLY is used.
--
Oliver Elphick Oliver(dot)Elphick(at)lfix(dot)co(dot)uk
Isle of Wight, UK http://www.lfix.co.uk/oliver
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C
========================================
"Love not the world, neither the things that are in the
world. If any man love the world, the love of the
Father is not in him...And the world passeth away, and
the lust thereof; but he that doeth the will of God
abideth for ever." I John 2:15,17
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Thomas Adam | 2003-02-02 12:09:28 | Oliver Elphick :-) |
| Previous Message | Peter Gibbs | 2003-02-02 10:48:40 | Re: Trigger problem |