--------------080305030701020307040608
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit

Not sure if postgresql is any different, but in MySQL when you add a 
column to a table and specify the default value for it, the column is 
set to that default value for all existing rows in the table.

dwh


Nic Xie wrote:
> I found I could not set it as a default. Because I have existing rows 
> and I want all of them have the type explicitly.
>
> To Robert, I only have this query running.
>
> Nic
>
>   
>

--------------080305030701020307040608--