"Matt Friedman" <matt(at)daart(dot)ca> writes:
> We are having what seems like a baffling problem to me.
> On occasion, our SELECTs will return zero rows when we know with certainty
> that they should be returning at least some rows. No error occurs, the
> select just behaves as if the db is empty or something.
What PG version is this? What does EXPLAIN show for the misbehaving
queries?
regards, tom lane