id summary reporter owner description type status component version severity resolution keywords cc stage has_patch needs_docs needs_tests needs_better_patch easy ui_ux 14879 Aggregates (Min, Max) for CharField fails with Postgresql wejaay Greg Wogan-Browne "If you try to do aggregate on a {{{CharField}}} using with Min or Max, it works fine in sqlite3 but fails in PostgresSQL. I have version 9.0 of postgres and latest dev version of django. The error occurs because Django is trying to convert the string to float in http://code.djangoproject.com/browser/django/trunk/django/db/backends/__init__.py?rev=9742, line number 399. Thats the version where this code was first introduced and as far as I can tell its been broken all the way from then to most recent version http://code.djangoproject.com/browser/django/trunk/django/db/backends/__init__.py, line 553. One fix that seems to work is to change line 549 from {{{ elif internal_type in ('DateField', 'DateTimeField', 'TimeField'):}}} to {{{elif internal_type in ('DateField', 'DateTimeField', 'TimeField', 'CharField'):}}} I dont know if that has other side effects. If I am doing something wrong, please let me know." Bug closed Database layer (models, ORM) dev Normal worksforme aggregate, postgresql, charfield mike@… Accepted 1 0 1 1 0 0