Contents

class User < ActiveRecord::Base
  has_many :comments

  auxiliary_statement :last_comment do |cte|
    cte.query Comment.distinct_on(:user_id).order(:user_id, id: :desc)
    cte.attributes id: :comment_id, content: :comment_content
  end
end

Version data entries

35 entries across 35 versions & 1 rubygems

Version	Path
torque-postgresql-2.2.3	spec/models/user.rb
torque-postgresql-2.2.2	spec/models/user.rb
torque-postgresql-2.2.1	spec/models/user.rb
torque-postgresql-2.2.0	spec/models/user.rb
torque-postgresql-2.1.3	spec/models/user.rb
torque-postgresql-2.1.2	spec/models/user.rb
torque-postgresql-2.1.1	spec/models/user.rb
torque-postgresql-2.1.0	spec/models/user.rb
torque-postgresql-2.0.6	spec/models/user.rb
torque-postgresql-2.0.5	spec/models/user.rb
torque-postgresql-2.0.4	spec/models/user.rb
torque-postgresql-2.0.3	spec/models/user.rb
torque-postgresql-2.0.2	spec/models/user.rb
torque-postgresql-2.0.1	spec/models/user.rb
torque-postgresql-2.0.0	spec/models/user.rb