The error which is seen so often:
for PostgreSQL (and the SQL92 standard AFAIK), all non-aggregated fields must be present in the GROUP BY clause.
In the case of the query below, this is the case for the vid & name fields, and also for the 'weight' field which is in the 'ORDER BY'.

This is a very standard bugreport/patch and should have zero effect on MySQL.

CommentFileSizeAuthor
tf_psql.patch458 bytesroderik

Comments

roderik’s picture

roderik
Primary language Dutch
Location Amsterdam,NL / Budapest,HU
commented
Status: Active » Needs review

Forgot to set status. Though IMHO this patch should just be applied, not reviewed by 'the community'.

solotandem’s picture

solotandem commented
Title: PostgreSQL error » PostgreSQL requires all non-aggregated fields to be present in the GROUP BY clause
Assigned: Unassigned » solotandem
Status: Needs review » Fixed

Thanks for spotting this.

Fixed in next dev release created after this comment.

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.