Question regarding threaded mode

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.