Ken Tozier <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
