Re: Adding Missing Data to a Table [SOLVED]

On Tue, 29 Mar 2011, Roderick A. Anderson wrote:

> A CAST should handle getting the data from the tmp_col back into record.
> The serial was a simple way to get the column incrementally filled.

Actually, CAST does not work from char/varchar to int, bigint, or numeric;
at least, it would not here with 9.0.3 up and running. Shrug.

I created a new column of type bigint, copied values from column record to
the new one, dropped the varchar column, and renamed the bigint column. Then
added a sequence and used that to add values to rows without them.

All's good now.

Thanks to everyone and especially Michael,

Rich