#1 ✓resolved
Maciej Litwiniuk

problem with ordering under postgres

Reported by Maciej Litwiniuk | September 20th, 2008 @ 05:52 PM

When sorting by column in project, that uses postgresql db, searchgasm throws following error: PGError: ERROR: column "products.invoice_symbol" must appear in the GROUP BY clause or be used in an aggregate function : SELECT count(*) AS count_all FROM "products" ORDER BY "products"."invoice_symbol" ASC Under mysql everything works just fine

Comments and changes to this ticket

Please Sign in or create a free account to add a new ticket.

With your very own profile, you can contribute to projects, track your activity, watch tickets, receive and update tickets through your email and much more.

New-ticket Create new ticket

Create your profile

Help contribute to this project by taking a few moments to create your personal profile. Create your profile ยป

Provides common named scopes and object based searching.

People watching this ticket

Referenced by

Pages