Horton

Re: Much Ado About COUNT(*)

Mark Kirkwood <markir@coretech.co.nz>

View thread
From: Mark Kirkwood <markir@coretech.co.nz>
To: "Jim C. Nasby" <decibel@decibel.org>
Cc: Ron Mayer <rm_pg@cheapcomplexdevices.com>, Bruce Momjian <pgman@candle.pha.pa.us>, pgsql-hackers@postgresql.org
Date: 2005-01-23T23:41:55Z
Lists: pgsql-hackers 
Jim C. Nasby wrote:

> Does anyone have working code they could contribute? It would be best to
> give at least an example in the docs. Even better would be something in
> pgfoundry that helps build a summary table and the rules/triggers you
> need to maintain it.

http://developer.postgresql.org/docs/postgres/plpgsql-trigger.html#PLPGSQL-TRIGGER-SUMMARY-EXAMPLE

regards

Mark