On 18 June 2011 18:02, James David Smith <james.david.smith@gmail.com> wrote:
> Thanks Thom.
>
> What does the ' ::int ' bit do at the end?
That casts the whole lot to an int value so that it can be assigned to
the column you're updating. Otherwise you could end up with an error
message saying the types don't match.
So ::int is equivalent to cast(column as int).
Thom