pjhyett (owner)

Revisions

gist: 12716 Download_button fork
public
Public Clone URL: git://gist.github.com/12716.git
Embed All Files: show embed
Text #
raw 
1
2
3
4
5
6

  has_many :unread_messages,

    :class_name  => 'Message',

    :foreign_key => :to_id,

    :conditions  => { :to_deleted => false, :unread => true },

    :group       => :source_id

 
Text only #
raw 
1
2

PGError: ERROR:  column "messages.id" must appear in the GROUP BY clause or be used in an aggregate function
: SELECT * FROM "messages"   WHERE ("messages".to_id = 48 AND ("messages"."to_deleted" = 'f' AND "messages"."unread" = 't'))  GROUP BY source_id