Reducing long space

 I am using a column of type long to store a potentially  large amount of text.

 I would like to create a "clean up" utility, which would leave  the tuple as it is, but remove the contents of this column  (by setting it to NULL) in order to reduce disk space.

1. Will this approach result in what I want to achieve?
2. If yes - would a regular UPDATE do, or would one have to do DELETE and INSERT?

  Regards
  /Johan Hellstrom Received on Fri Apr 15 1994 - 15:29:55 CEST