"Joshua D. Drake" <jd@xxxxxxxxxxxxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
