Trigger on select

[omri swissa]

Hi,
I know triggers can be on Insert, Update, Delete and etc… but not on select statements. I wonder if there is a way that I can put a trigger or something else on select. What I’m looking for is a “select rule”.
For example: if I have table named “tb_example” with the following columns: “id, name”. I want to set a rule that every select "when id <0 return id = 0".

So this query: “select * from tb_example where id = -8” and this query: “select * from tb_example where id = 0” will return the same value.

Do you know something that fits to what I’m looking for?

Thanks,
Omri