On 11/28/11 4:36 AM, JavaNoobie wrote:
Well I'm not fond of using a temporary table either. But how would I be able
to iterate over a set of consumers while using a join ? From my (limited) ,
using only a join I would only be able to generate the data for a particular
consumer , rather than all of them.
get rid of
db_consumer_pump_details.consumer_id=i and
and the limit, and the join will do all of them. But, maybe I don't
quite understand what it is you're doing.
--
john r pierce N 37, W 122
santa cruz ca mid-left coast
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
