Question 114596 in PostgreSQL Question posted in
The official documentation can be found here.

Postgresql – null value in column "balance" violates not-null constraint

I want to update balance from another table, with sum function but im getting this error:

null value in column "balance" violates not-null constraint

Any suggestion how can i check to not update null values or to change query so that works?

This is my query:

update apt_profile 
set payment_currency_code ='CC',
balance =  (select sum(open_amount_total) from fnt_pym_profile where fnt_pym_profile.profile_id =apt_profile.id and status ='OPEN')
where payment_currency_code ='DD';
Tags:

2

Answers


  1. 0

    Use COALESCE.

    update apt_profile 
set payment_currency_code ='CC',
balance = coalesce(select sum(open_amount_total) from fnt_pym_profile where fnt_pym_profile.profile_id =apt_profile.id and status ='OPEN'), 0)
where payment_currency_code ='DD';

    This should 0 the balance.

    Login or Signup to reply.
  2. 0

    OR use ISNULL:

    update apt_profile
set payment_currency_code ='CC',
balance =  ISNULL(select sum(open_amount_total) from fnt_pym_profile where fnt_pym_profile.profile_id =apt_profile.id and status ='OPEN'), 0)
where payment_currency_code ='DD';
    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search