| From: | John R Pierce <pierce(at)hogranch(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Stored function debugging help |
| Date: | 2011-11-28 21:30:24 |
| Message-ID: | 4ED3FD70.8070605@hogranch.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | panam | 2011-11-29 00:14:11 | Extending the volume size of the data directory volume |
| Previous Message | Stefan Keller | 2011-11-28 21:24:36 | Any experiences with Foreign Data Wrappers (FDW) like mysql_fdw, odbc_fdw, www_fdw or odbc_fdw? |