postgresql中使用group by出现column "" must appear in the GROUP BY clause or be used in an aggregate function [ Trailblazer ]

postgresql中使用group by出现column "" must appear in the GROUP BY clause or be used in an aggregate function

发表于 [2023-07-24 16:35:00]，更新于 [2023-07-24 16:38:22]
总字数 [229]，阅读时长 [约1分钟]，阅读量 [ 未知 ]
publish by lensfrex

select c.id,
       c."name" course_name, array_agg(ti.name) teachers, c.course_hours, c.spring_term, c.target_major, c.target_grade,
       cs.id schedule_id, cs.start_week, cs.end_week, cs.time, cs.academic_term, cs.place, cs.ratio
from course c
         left join (teacher_course tc inner join teacher_info ti
                    on tc.teacher = ti.id and tc.course = '1') on tc.course = c.id
         inner join course_schedule cs on c.id = cs.course
where c.id = '1'
group by (
  c.id, c."name", c.course_hours, c.spring_term, c.target_major, c.target_grade, 
  cs.id, cs.start_week, cs.end_week, cs.time, cs.academic_term, cs.place, cs.ratio
)