KÖPFERL Robert wrote: >I'm a little bit perplexed now... is it really the case that pre 8.0 systems >aren't able to change col-types?
I would guess that the column type altering code is just short hand for creating a new column of the correct type, copying the old column into the new one, deleting the old column, and renaming the new column to be the same as the old one. That is just a guess though! But if it's all bundled inside a transaction it should have about the same semantics, shouldn't it? Cheers, Sam ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])