Greetings! What is the 'best way' or 'guiding philosophy' if there is one for dealing with calculated values in a pg database? For example, say you have a table with a column of floats, and you want to make a view showing this column as a percent of the total across the column. Should you a) create another table with the total, and put on triggers on insert, update, and delete to modify the right total or b) create the view with a specific subselect to recalculate the total at select time. This has the disadvantage that the total seems to be recalculated for each row. Is there any sql syntax which can merge a dynamically generated aggregate, *calculated only once*, into each output row? Thanks! -- Camm Maguire [EMAIL PROTECTED] ========================================================================== "The earth is but one country, and mankind its citizens." -- Baha'u'llah
