Re: [GENERAL] Postgres inherited table, some questions...

2004-09-29 Thread Thomas F . O'Connell
Well, considering that the EXPLAIN tables are different from tablea/tableb, I can only assume that your jobdata tables follow the same pattern. Are you familiar with the ONLY syntax for SELECT when using inheritance? It looks like you might need to SELECT ONLY ... FROM tableb. -tfo On Sep 29,

Re: [GENERAL] Postgres inherited table, some questions...

2004-09-29 Thread Net Virtual Mailing Lists
Hello, I hate to re-ask this again (sorry to be repetitive!)... I really could use some help with this, if anyone is familiar with table inheritance as it applies to my questions Thanks! - Greg >Hello, > >I am playing with the "INHERITS" functionality of create table to >determine its suita