On 8 Aug 2002, Neil Conway wrote:
> "Nigel J. Andrews" <nandrews@investsystems.co.uk> writes:
> > I have this query which used to yield this EXPLAIN ANALYZE
> > [reformated] output:
>
> Uh, *which* query, exactly?
Hmmm...I suppose I should have written 'I have a query...'
Never mind I'll repost the whole message along with the query, just so that
it's all together for easier reference.
The query refered to in the post below:
explain analyze
select u.name
, p.session_id
, p.post_number
, to_char(p.time,'Dy, Mon DD YYYY HH:MIam ET')
from chat_post p
, chat_user u
where
p.poster_id = u.id
AND
p.time >= 'epoch'::timestamptz + '959904000 seconds'::interval
and
p.time <= 'epoch'::timestamptz + '1023667200 seconds'::interval
and
( u.lower_name = 'thrifty' OR u.lower_name = 'hope1' )
order by p.time
---