Error for the creation of the DB for Postgres

[stephane303]

I am using Postgres 12, and I had to modify your script located here db\migration\dev\postgresql\V1.1__Create.sql to make it work:

CREATE OR REPLACE FUNCTION "update_msrp" (IN "id" BIGINT, IN "debit" INT)
RETURNS REAL
AS $$
UPDATE "public"."product"
SET "msrp" = "public"."product"."msrp" - "debit"
WHERE "public"."product"."product_id" = "id"
RETURNING "public"."product"."msrp";
$$ LANGUAGE sql;

=>
ERROR: Actual return type is numeric.return type mismatch in function declared to return real

ERROR: return type mismatch in function declared to return real
SQL state: 42P13
Detail: Actual return type is numeric.
Context: SQL function "update_msrp"

The following is working

CREATE OR REPLACE FUNCTION "update_msrp" (IN "id" BIGINT, IN "debit" INT)
RETURNS NUMERIC
AS $$
UPDATE "public"."product"
SET "msrp" = "public"."product"."msrp" - "debit"
WHERE "public"."product"."product_id" = "id"
RETURNING "public"."product"."msrp";
$$ LANGUAGE sql;

[AnghelLeonard]

I used PostgreSQL 13. I'm glad that you made it work :) Thanks!