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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
