Philip Molter <[EMAIL PROTECTED]> writes:
> Is there anything I should specifically be looking for?
The only guess I have at the moment is that maybe the stacommonval
(most common value) of the 'deleted' or 'running' column matches the
query in one state and not the other. But please, just send
On Thu, Jul 05, 2001 at 12:05:52PM -0400, Tom Lane wrote:
: Hmm. Nothing out of the ordinary about the table schemas. The relevant
: bits of the query seem to be
:
: > FROM percept p
: > INNER JOIN perceptType pt ON pt.ptid=p.ptid
: >AND pt.runinterval IS NO
Hmm. Nothing out of the ordinary about the table schemas. The relevant
bits of the query seem to be
> FROM percept p
> INNER JOIN perceptType pt ON pt.ptid=p.ptid
>AND pt.runinterval IS NOT NULL
>WHERE p.deleted=0 AND UNIX_TIMESTAMP( p.nextrun )<=NO
