Re: ON CONFLICT DO UPDATE

Yes, that's what I figured out eventually. I thought, only the columns that
I declared inside the ON CONFLICT() parenthesis can be called in SET. My
bad.

On Thu, May 10, 2018 at 5:57 PM, Alban Hertroys <haramrae(at)gmail(dot)com> wrote:

>
> > On 10 May 2018, at 7:13, tango ward <tangoward15(at)gmail(dot)com> wrote:
>
> > ON CONFLICT (school_system_id,
> > student_id,
> > campus_name
> > ) DO UPDATE
> > SET school_system_id =
> excluded.school_system_id,
> > student_id = excluded.student_id,
> > campus_name = excluded.campus_name
>
> I'm pretty sure this ought to read:
> ON CONFLICT (school_system_id, student_id, campus_name)
> DO
> UPDATE SET modified = EXCLUDED.modified,
> balance = EXCLUDED.balance,
> balance_as_of = EXCLUDED.balance_as_of
>
> Instead, you were re-assigning the keys (school_system_id, student_id,
> campus_name) to the same values again.
>
> Alban Hertroys
> --
> If you can't see the forest for the trees,
> cut the trees and you'll find there is no forest.
>
>