Re: [GENERAL] help with design of the 'COUNT(*) in separate table schema

2010-10-20 Thread Peter Geoghegan
On 20 October 2010 23:52, Dennis Gearon wrote: > Regarding the previously discussed triggers on tables to keep track of count: > http://www.varlena.com/GeneralBits/120.php > http://www.varlena.com/GeneralBits/49.php > > CREATE OR REPLACE FUNCTION count_rows() > RETURNS TRIGGER AS > ' >   BEGIN >

[GENERAL] help with design of the 'COUNT(*) in separate table schema

2010-10-20 Thread Dennis Gearon
Regarding the previously discussed triggers on tables to keep track of count: http://www.varlena.com/GeneralBits/120.php http://www.varlena.com/GeneralBits/49.php CREATE OR REPLACE FUNCTION count_rows() RETURNS TRIGGER AS ' BEGIN IF TG_OP = ''INSERT'' THEN UPDATE rowcount