You have these choices:
- turn events into INSERTs and UPDATES on a table that represents a single call
You might have an events VIEW with INSTED OF insert/update triggers so you can insert events as the interface for
updatingcalls.
- store the events and have a VIEW on the events table that gives you rows that summarize each call
- both: store the events and the summaries of the calls
You might have an events table with AFTER INSERT triggers to insert or update the corresponding rows in the calls
table.
Nico
--
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general