Hello, I'm writing a large pl/pgSQL function to batch process raw sales records into departmentalised totals, stored in a dedicated table. The logical thing to do is to INSERT a conditional aggregate ( INSERT INTO ..... SELECT SUM CASE WHEN ...ELSE... FROM..... GROUP BY ....) INTO that dedicated table.
However, I need to do things like INSERT special records into some other table sometimes. For example, if the sales were made on credit, I need to make a dedicated record of that in the credit accounts table. I'd like to do this within the conditional aggregate, when it encounters a record that requires it, because that's more logical, direct and efficient, rather then do the aggregate and then do separate,"special" things on the same data. Is this possible? If not, could someone write some psuedo code that would accomplish the same think efficiently using cursors or something? Thanks, Peter Geoghegan -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
