I recently migrated my back end from PostGRES to MySQL. I was surprised to find out about the lack of support for “distinct” queries outside of PostGRES, per the documentation. Why is this? Thanks.
it not related to django but to the db itself , since mysql doesn’t support “distinct on” django couldn’t use it.
Thanks for the info. I would seem that maintaining access to “distinct” queries by field would be ideal. Was there no way to write a method for a "select distinct [columnA], [columnB], … " statement for MySQL and other dbs that don’t support “distinct on”?
the only db i know supports it is postgres