diff options
| author | Tom Lane <tgl@sss.pgh.pa.us> | 2005-01-15 03:38:44 +0000 |
|---|---|---|
| committer | Tom Lane <tgl@sss.pgh.pa.us> | 2005-01-15 03:38:44 +0000 |
| commit | 893c66de69a02d8e9ee83fb0fcdb284d01105e1d (patch) | |
| tree | b81c5509840eadc23123e2018cc73cde4efc154b | |
| parent | 2c1abfd979bcd0e5ea97ffd2c5b33a87de840b9f (diff) | |
| download | postgresql-893c66de69a02d8e9ee83fb0fcdb284d01105e1d.tar.gz postgresql-893c66de69a02d8e9ee83fb0fcdb284d01105e1d.zip | |
Simplify trigger example, per Mark Kirkwood.
| -rw-r--r-- | doc/src/sgml/plpgsql.sgml | 19 |
1 files changed, 7 insertions, 12 deletions
diff --git a/doc/src/sgml/plpgsql.sgml b/doc/src/sgml/plpgsql.sgml index 3842ee5ef7c..3a283bce5e4 100644 --- a/doc/src/sgml/plpgsql.sgml +++ b/doc/src/sgml/plpgsql.sgml @@ -1,5 +1,5 @@ <!-- -$PostgreSQL: pgsql/doc/src/sgml/plpgsql.sgml,v 1.56 2005/01/14 01:16:22 tgl Exp $ +$PostgreSQL: pgsql/doc/src/sgml/plpgsql.sgml,v 1.57 2005/01/15 03:38:44 tgl Exp $ --> <chapter id="plpgsql"> @@ -2787,17 +2787,12 @@ CREATE OR REPLACE FUNCTION maint_sales_summary_bytime() RETURNS TRIGGER AS $main amount_sold, units_sold, amount_cost) - SELECT f.time_key, - sum(f.amount_sold), - sum(f.units_sold), - sum(f.amount_cost) - FROM sales_fact f - WHERE f.time_key = delta_time_key - GROUP BY f.time_key; - -- This query can potentially be very expensive if the trigger - -- is created on sales_fact without the time_key indexes. - -- Some care is needed to ensure that this situation does - -- *not* occur. + VALUES ( + delta_time_key, + delta_amount_sold, + delta_units_sold, + delta_amount_cost + ); EXCEPTION -- -- Catch race condition when two transactions are adding data |