Re: SELECT (sometimes) returning Zero Rows? - Mailing list pgsql-general

From Tom Lane
Subject Re: SELECT (sometimes) returning Zero Rows?
Date
Msg-id 11929.982107986@sss.pgh.pa.us
Whole thread Raw
In response to SELECT (sometimes) returning Zero Rows?  ("Matt Friedman" <matt@daart.ca>)
List pgsql-general
"Matt Friedman" <matt@daart.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

pgsql-general by date:

Previous
From: "Mitch Vincent"
Date:
Subject: Re: Re: Order question
Next
From: Justin Clift
Date:
Subject: PostgreSQL non-FAQ documentation