Re: Inheritance and views

On Wed, Apr 04, 2001 at 02:07:13PM +0200, DaVinci wrote:
>  Hello.
>
>  I'd like to implement for my DB a mechanism of backup based in inherited
>  tables. I explain it in detail:
>
>  Idea is simple: table B inherits from table A. Anualy, data from table A is
>  dumped in B. So, from frontend it is posible to access current data (from
>  A) or all data (A + B).
>
>  Problem is that I'd like also implement a view for A and B, but I don't
>  know what is best way. View(s) must have rules for insert and update. Can
>  view from A access data from B without problem (eliminating "ONLY" from
>  select)?. Is there another better form of implementing this backup
>  mechanism?. I'd not want to reinvent the wheel ;)
>
>  Thanks for your ideas.

Maybe...

SELECT * FROM A* ;

Notice the asterisk on the superclass table name.

--
Eric G. Miller <egm2@jps.net>