dvS6zCwD

1DROP TABLE IF EXISTS config.trading_holiday;
2CREATE TABLE config.trading_holiday
3(
4  id smallint GENERATED ALWAYS AS IDENTITY NOT NULL,
5  holiday_date DATE,
6  name VARCHAR(80)
7);
8ALTER TABLE config.trading_holiday
9  ADD CONSTRAINT trading_holiday_pk
10  PRIMARY KEY (id);
11	
12DROP PROCEDURE IF EXISTS config.sp_add_holiday(holiday_date DATE, 
13                                               name CHARACTER VARYING);
14
15CREATE PROCEDURE config.sp_add_holiday(holiday_date DATE, 
16                                       name CHARACTER VARYING)
17AS $$
18BEGIN
19  INSERT INTO config.trading_holiday(holiday_date,name)
20    VALUES(sp_add_holiday.holiday_date,sp_add_holiday.name);
21END
22$$
23LANGUAGE PLPGSQL;
24	
25CALL sp_add_holiday(holiday_date='2018-01-01',name='New Years Day');
26	
27[2018-08-07 11:56:18] [42703] ERROR: column "holiday_date" does not exist
28[2018-08-07 11:56:18] Position: 21
29	
30INSERT INTO config.trading_holiday(holiday_date,name)
31  VALUES('2018-01-01','New Years Day');
32	
33[2018-08-07 12:04:01] 1 row affected in 2 ms