SqYu5iGS

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 CHARACTER VARYING(80)
7);
8ALTER TABLE config.trading_holiday
9  ADD CONSTRAINT trading_holiday_pk
10  PRIMARY KEY (id);
11	
12CREATE OR REPLACE PROCEDURE config.sp_add_holiday(holiday_date DATE, 
13                                                  name CHARACTER VARYING(80))
14AS $$
15BEGIN
16  INSERT INTO config.trading_holiday(holiday_date,name)
17    VALUES(sp_add_holiday.holiday_date,sp_add_holiday.name);
18END
19$$
20LANGUAGE PLPGSQL;
21	
22CALL config.sp_add_holiday(holiday_date='2018-01-01',name='New Years Day');
23	
24[2018-08-07 11:56:18] [42703] ERROR: column "holiday_date" does not exist
25[2018-08-07 11:56:18] Position: 21
26	
27INSERT INTO config.trading_holiday(holiday_date,name)
28  VALUES('2018-01-01','New Years Day');
29	
30[2018-08-07 12:04:01] 1 row affected in 2 ms
31	
32CREATE OR REPLACE PROCEDURE config.sp_add_holiday(in_holiday_date DATE, 
33                                                  in_name CHARACTER VARYING(80))
34AS $$
35BEGIN
36  INSERT INTO config.trading_holiday(holiday_date,name)
37    VALUES (in_holiday_date, in_name);
38END
39$$
40LANGUAGE PLPGSQL;
41	
42CALL config.sp_add_holiday(holiday_date => '2018-01-01', name => 'New Years Day');
43	
44ERROR: column "holiday_date" does not exist