| From: | Mark Kirkwood <markir(at)coretech(dot)co(dot)nz> |
|---|---|
| To: | pgsql-patches(at)postgresql(dot)org |
| Subject: | Another Plpgsql trigger example - summary table |
| Date: | 2004-12-29 03:03:24 |
| Message-ID: | 41D21E7C.2040702@coretech.co.nz |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-patches |
I have always thought that an example of how to maintain a summary table
via triggers would be nice... but until the other day, had not attempted
to do one, so contributing a simplified version seemed like a good thing
to do.
I have made the example pretty much self contained, which unfortunately
means it is longish. This made me wonder about its placement (i.e in
plpgsql examples). It could go in a 'Data warehousing' chapter - if we
had one....
Any suggestions welcome.
best wishes
Mark
P.s : use is made of a schema from Ralph Kimball's "The Data Warehouse
Toolkit" - I mailed him to check it was ok (and it was, in fact he was
quite pleased)
| Attachment | Content-Type | Size |
|---|---|---|
| plpgsql.sgml.diff | text/plain | 10.1 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Stephen Frost | 2004-12-29 15:46:14 | Grammer Cleanup |
| Previous Message | Mark Kirkwood | 2004-12-28 23:20:25 | Re: Bgwriter behavior |