loop infinito en triggers

que tal lista,

una consulta, que pasa si defino un trigger que se dispare al hacerse un
insert, y dentro del codigo del trigger hago un insert en la misma tabla?

se produce un loop infinito?

salu2
gonzalo

--
When things are investigated, then true knowledge is achieved;
when true knowledge is achieved, then the will becomes sincere;
when the will becomes sincere, then the heart sees correctly;
when the heart sees correctly, then the personal life is cultivated;
when the personal life is cultivated, then the family life is regulated;
when the family life is regulated, then the national life is orderly;
and when the national life is orderly, then there is peace in this world.

Confucius