Search Postgresql Archives

Re: aggregate functions are not allowed in UPDATE

Subject: Re: aggregate functions are not allowed in UPDATE
From: Alexander Farber <alexander.farber@xxxxxxxxx>
Date: Tue, 15 Jan 2019 20:23:33 +0100
Cc: pgsql-general <pgsql-general@xxxxxxxxxxxxxx>
In-reply-to: <CAADeyWhb9FDLUX=c0quhONxzrkp9j9Gf2yr=Xp0f2Qautiu+oQ@mail.gmail.com>
References: <CAADeyWiQ6cnLR9C7xWnv5Y35-v+m6XR0nmRiPZ7kWbEOfyeB_Q@mail.gmail.com> <CAKFQuwaN3FoNqjGEzKTaZhO=5d4qR2LgHk-4AF7cQ2DreLNxXg@mail.gmail.com> <CAADeyWiVAsnox5NBp5YMKHVgGT7VR0uACLXUR6O8hWsdQ0xsfQ@mail.gmail.com> <CAKFQuwZBstZizu2rEuB+ML5td2XqYNFMd_StGkaKQ5wCp+rB1A@mail.gmail.com> <CAADeyWhb9FDLUX=c0quhONxzrkp9j9Gf2yr=Xp0f2Qautiu+oQ@mail.gmail.com>

And I should better change the avg_time column from TEXT to TIMESTAMPTZ (and use TO_CHAR on it later down the road) so that I can compare my players

Regards

Alex

Follow-Ups:
- Re: aggregate functions are not allowed in UPDATE
  - From: Alexander Farber

References:
- aggregate functions are not allowed in UPDATE
  - From: Alexander Farber
- Re: aggregate functions are not allowed in UPDATE
  - From: David G. Johnston
- Re: aggregate functions are not allowed in UPDATE
  - From: Alexander Farber
- Re: aggregate functions are not allowed in UPDATE
  - From: David G. Johnston
- Re: aggregate functions are not allowed in UPDATE
  - From: Alexander Farber