Re: Modifying SET columns

[Paul DuBois]

At 3:55 PM -0400 8/22/99, Andrian Pervazov wrote:
>Let's say I have a table where one of the fields is of the type SET, 
>with values
>SET('red','green',blue'). At some point I decide that 'red' should 
>be changed to
>'darkred'. I do it with the ALTER TABLE ... 
>SET('darkred','green','blue') statement.
>Now, I would normally expect that all the records which used to be 'red' would
>automatically become 'darkred'. However, they are all unset, i.e. 
>set to an empty
>value.


Why do you expect that?

-- 
Paul DuBois, paul@stripped