Re: [GENERAL] SELECT (sometimes) returning Zero Rows?

[Tom Lane]

"Matt Friedman" <[EMAIL PROTECTED]> 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