"Slavcho Ivanov" <[EMAIL PROTECTED]> writes:
> The query was as simple as possible
> "select * from data where "SensorID" = 18",
> and the result had a couple of rows where SensorID was NOT 18, but 3.
That's not too surprising if the index had gotten corrupted somehow,
but since you haven't provided any details that would let someone else
reproduce the problem, there's not much we can do with this report :-(
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
