First, I appreciate PostgreSQL's extensive support for SQL and its
feature set greatly, which is why I use it, because of its extensive and
powerful features not found on some other SQL implementations and I hope
that the capabilities of it will continue to be expanded and improved.
Does PostGRESQL support or will it support a threaded server mode? Will
such a mode be available on Unix-type systems?
Also, has PostgreSQL considered adding some CLOB and BLOB types?
Updating Views
Triggers on Views
Additional Trigger Syntax (ie Oracle):
CREATE [OR REPLACE] TRIGGER <trigger_name>
{BEFORE|AFTER} {INSERT|DELETE|UPDATE} ON <table_name>
[REFERENCING [NEW AS <new_row_name>] [OLD AS <old_row_name>]]
[FOR EACH ROW [WHEN (<trigger_condition>)]]
<trigger_body>
Thank you.