"Joshua D. Drake" <jd(at)commandprompt(dot)com> writes:
> On Tue, 2011-02-01 at 12:14 +0600, AI Rumman wrote:
>> I migrated my DB from Postgresql 8.1 to Postgresql 9.0.1.
>>
>> I have a table "testtab"
>> \d testtab
>> id int,
>> hours varchar
>>
>> When I execute the following:
>> select sum(hours) from testtab
>> I get cast error.
>>
> In 8.3, implicit casts were removed. You can't sum text.
You couldn't do it in previous releases, either.
regards, tom lane