Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #6416: Expression index not used with UNION ALL queries - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #6416: Expression index not used with UNION ALL queries
Date
Msg-id 14415.1327872793@sss.pgh.pa.us
Whole thread Raw
In response to Re: BUG #6416: Expression index not used with UNION ALL queries  (Matteo Beccati <php@beccati.com>)
Responses Re: BUG #6416: Expression index not used with UNION ALL queries  (Matteo Beccati <php@beccati.com>)
List pgsql-bugs
Tree view 
Matteo Beccati <php@beccati.com> writes:
>> I've just noticed that an expression index I've created was not used with a
>> view contiaining a UNION ALL. Switching to UNION or querying the table
>> directly works as expected.

Looks like I broke this back in November :-(.  Fixed, thanks for the
report.

            regards, tom lane

pgsql-bugs by date:

Previous
From: Peter Geoghegan
Date:
Subject: Re: wCTE cannot be used to update parent inheritance table
Next
From: Peter Geoghegan
Date:
Subject: Re: wCTE cannot be used to update parent inheritance table