Hi, not sure if this bug is already known, so sorry if it is ;)
This is about an issue of the optimizer when having a union of selects
that yield columns of constant value.
The first minimal example shows a regression, the second one a missed
optimization.
Cheers,
Claus
Example 1:
The following bug has been logged on the website:
Bug reference: 6510
Logged by: Alexander LAW
Email address: exclus...@gmail.com
PostgreSQL version: 9.1.3
Operating system: Windows
Description:
I'm using postgresSQL in Windows with Russian locale and get unreadable