I would disagree with the above. Any time you are taking a ratio of 2 numbers be it risk (as in relative risk) or odds (as in odds ratio), a 1 is always NOT significant because mathematically it signifies that the 2 numbers are the same and you get a ratio = 1. The only exception is relative risk reduction which has 2 steps with the first being a subtraction (see below).
In the case of a CI that includes 0, the only time that is NOT significant is when your calculations involve a subtraction such as absolute risk or a risk reduction (absolute or relative). In that case, if the two numbers you are comparing is the same, then the subtraction will give you a 0 meaning it's NOT significant.
Edit: I think the document in the link above agrees with me on pg.3 when it says the measure of no effect for both RR and OR would be 1.