Mod coding: avoiding update clashes...

[Pedro!]

Hi all, apologies if this has been asked before but I have searched and haven't managed to pinpoint anything...

My question is this:

In the install/update XML for my product if I have this in the <codes> area of the XML:

<codes>
	<code version="0.92">
				<installcode><![CDATA[
						//do some database stuff here
				]]
				</installcode>
	</code>

	<code version="0.93">
				<installcode><![CDATA[
						//do something that is required for the new version here
				]]
				</installcode>
	</code>
</codes>

If someone who is running version 0.92 of my mod updates will only the <code version="0.93"> section of the code run?

On a similar note if someone who is running, say, version 0.9 of my mod, will both sections of the code run?

The reason I ask is that I have an INSERT INTO query in the 0.92 section which will probably throw an error if it runs twice.

I hope I explained this clearly!

Any help will be much appreciated, thanks.