Re: [GENERAL] inheritance and index use (similar to UNION ALL)

2006-12-11 Thread Karsten Hilbert
06 at 09:43:35AM +0100, Karsten Hilbert wrote: > Subject: [GENERAL] inheritance and index use (similar to UNION ALL) > User-Agent: Mutt/1.5.13 (2006-08-11) > > Hi, > > we have a parent table root_item with a few common fields > (one is a text field) from which a whole bunch

[GENERAL] inheritance and index use (similar to UNION ALL)

2006-12-11 Thread Karsten Hilbert
Hi, we have a parent table root_item with a few common fields (one is a text field) from which a whole bunch of child tables derives. We need to run queries against the text field across the whole bunch of child tables. What naturally comes to mind is to run the query against root_item.text_field