Manuel García wrote:
Hello Everybody, somebody knows if its possible to catch one sentences in full SQL using the triggers, or maybe somebody have any idea about to how do it? I am using postgreSQL 7.3 on fedora core 1
If I understand, you want to access the query, e.g. "SELECT * FROM my_table" from within a trigger function. The answer is no. If you can describe what you're trying to do, someone may be able to help though.
-- Richard Huxton Archonet Ltd ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match