Hi, I think I could write a script to do something similar to what is happening if anyone is interested. I'd want some direction as to the best way to handle this though: it'd be easier for me to script it as Rails code because that's what the app is. Perhaps from that we can get the generated SQL so as to make it easier for others to deal with. The operation itself is basically: * Extract a value from a row of a table that is stored as a bytea. * Unmarshall it into a Ruby object. * Add to that Ruby object. * update the row and set the value by marshalling the Ruby object. I suspect that the actual value isn't terribly relevant, and they how's and why's of what it is like it is are best left for a different discussion. -- David N. Welton http://www.dedasys.com/ -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general