Logging user queries - Trigger for Select?

Logging user queries - Trigger for Select?

Federal laws (HIPAA) in the US are going to require
the tracking of all access (even SELECT) to certain
fields of protected patient information.  The simplest
way that I (not a developer) can think of to
accomplish this is to have a trigger store query
history in a log table.

1.  How can I capture the text of an SQL query (not
the result set) so that it can be used as a value in
an INSERT statement.

2.  Would the PostgreSQL developers consider expanding
the scope of Triggers to include SELECT statements?
(please?)

Thanks,
Andrew Gould

__________________________________________________
Do You Yahoo!?
Yahoo! Sports - Coverage of the 2002 Olympic Games
http://sports.yahoo.com