On 11/28/11 1:30 AM, JavaNoobie wrote:
1) Get a list of all the consumers and store their id's stored in a temp
table.
2) Iterate over a particular table and retrieve values corresponding to each
value from the above list and store in a temp table.
3)Return the temp table.

couldn't that all be done by a JOIN without involving a temporary table, or iteration?

this seems like a conventional programmers approach to problem solving, rather than using the power of the relational database.



--
john r pierce                            N 37, W 122
santa cruz ca                         mid-left coast


--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply via email to