View difference between Paste ID: 1zWYxSZZ and MqKNQ8e9

 CREATE TABLE bank_transactions
 (
   id serial NOT NULL,
   transaction_date date,
   amount numeric(20,2),
   customer_id integer NOT NULL,
   deleted boolean DEFAULT false,
   CONSTRAINT bank_transactions_pkey PRIMARY KEY (id )
 );
 
 WITH RECURSIVE bank(id,amount) AS (
   SELECT ARRAY[id],amount::numeric FROM bank_transactions
   UNION ALL
   SELECT b1.id||ARRAY[borg.id],b1.amount+borg.amount
   FROM bank AS b1 LEFT JOIN
   bank_transactions AS borg ON borg.id>ALL(b1.id)
 )
 SELECT * from bank LIMIT 100;
 
 ERROR:  recursive query "bank" column 2 has type numeric(20,2) in non-recursive term but type numeric overall
 LINE 6:   SELECT ARRAY[id],amount::numeric FROM bank_transactions
                            ^
 HINT:  Cast the output of the non-recursive term to the correct type.
 
 ********** Error **********
 
 ERROR: recursive query "bank" column 2 has type numeric(20,2) in non-recursive term but type numeric overall
 SQL state: 42804
 Hint: Cast the output of the non-recursive term to the correct type.
 Character: 140