Re: [BUGS] BUG #6416: Expression index not used with UNION ALL queries

2012-01-30 Thread Matteo Beccati
On 29/01/2012 22:33, Tom Lane wrote: Matteo Beccati p...@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

Re: [BUGS] BUG #6416: Expression index not used with UNION ALL queries

2012-01-29 Thread Matteo Beccati
On 29/01/2012 16:06, p...@beccati.com wrote: The following bug has been logged on the website: Bug reference: 6416 Logged by: Matteo Beccati Email address: p...@beccati.com PostgreSQL version: 9.1.2 Operating system: Debian Sqeeze Description: I've just

Re: [BUGS] BUG #6416: Expression index not used with UNION ALL queries

2012-01-29 Thread Tom Lane
Matteo Beccati p...@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.