On Tue, 2004-07-20 at 15:36, Jeff Boes wrote:
...
> Of course, had we used table inheritance, we'd do something like ...
>
>select * from draft_template ...
>
> but it wouldn't do exactly what we are doing now: that is,
> fn_all_drafts() returns not only the contents of every row in the table
This feels like a flaw in the way inherited tables work.
I have a "template" table used to create other tables (but not by
inheritance; instead the "daughter" tables are created via
create table draft_00123 as select * from draft_template where false;
This is done for somewhat historical reasons,