On Monday 27 March 2006 13:57, Jim C. Nasby wrote: > BTW, you might also find inheritance to be of use: > http://www.postgresql.org/docs/8.1/interactive/ddl-inherit.html I'm not sure inheritance will help here or not. I need to aggregate all the sub tables and add a field whose value depends on which table the data came from. I think views are probably easier but I've never actually used table inheritance. Ashley
