Ken Tozier <kentozier@comcast.net> writes:
> When I add the OR clause things go haywire:
> SELECT a.paginator, a.doc_name, (b.time - pm_events.time) as
> elapsed_time FROM pm_events as a, pm_events as b
> WHERE a.event_code='pmcd'
> OR a.event_code='pmop'
> AND b.event_code='pmcl'
> AND a.doc_name=b.doc_name
> AND a.paginator=b.paginator
> AND a.time < b.time
I think you need some parentheses, or at least a bit of thought about
what the OR is binding to.
regards, tom lane