Bill Moseley writes: > PostgreSQL 7.4.8 on i486-pc-linux-gnu, compiled by GCC cc (GCC) 4.0.2 20050816 (prerelease) (Debian 4.0.1-5) > > Hopefully this is something simple -- I assume it's a problem with my > SQL. But it looks really weird to me at this late hour. > > I have some tables for managing workshops, and I have a view (below). > I noticed for a given select it was returning the wrong number of > rows. I expected seven rows back, but only got six. > > I rewrote the view with just the joins and it returned the correct number > of rows. So I started the brute force method of removing one thing at > a time in the view to see what would make it start returning the > correct number of rows. That just confused me more. How does the query plan change when you make those changes? If it only occurs if a certain index is used, it might be corrupt (=> REINDEX). regards, Andreas ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
