Re: Postgres query completion status?

Richard Neill  wrote:

> SELECT ( core.demand.qty - viwcs.wave_end_demand.qty_remaining )
>   FROM
>     core.demand,
>     viwcs.previous_wave
>     LEFT OUTER JOIN viwcs.wave_end_demand USING ( wid )
>   WHERE core.demand.id = viwcs.wave_end_demand.demand_id;

For comparison, how does this do?:

SELECT (core.demand.qty - viwcs.wave_end_demand.qty_remaining)
  FROM core.demand,
  JOIN viwcs.previous_wave
    ON (core.demand.id = viwcs.wave_end_demand.demand_id)
  LEFT OUTER JOIN viwcs.wave_end_demand USING (wid);

-Kevin