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
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