Re: [BUGS] Incorrect Sort Using Index Scan

2012-09-17 Thread Tom Lane
"McGehee, Robert" writes: > I have recently upgraded to PostgreSQL 9.2.0 and one of my queries is now > giving incorrectly sorted results due, I believe, to the new index-only scan > in 9.2.0. The below table is a table of currency FX rates by date. Hmm, no it's not about index-only scans (your

[BUGS] Incorrect Sort Using Index Scan

2012-09-17 Thread McGehee, Robert
Hello, I have recently upgraded to PostgreSQL 9.2.0 and one of my queries is now giving incorrectly sorted results due, I believe, to the new index-only scan in 9.2.0. The below table is a table of currency FX rates by date. template1=# \d fx0; Table "public.fx0" Column |