Changes between Version 30 and Version 31 of DatabaseProgramming
- Timestamp:
- 06/30/26 22:12:08 (5 days ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
DatabaseProgramming
v30 v31 11 11 12 12 CREATE OR REPLACE FUNCTION get_current_price(p_ticket_id BIGINT) 13 RETURNS DECIMAL(10,2) LANGUAGE plpgsql AS $$ 13 RETURNS DECIMAL(10,2) 14 LANGUAGE plpgsql 15 AS $$ 14 16 DECLARE 15 17 v_base_price DECIMAL(10,2); … … 46 48 47 49 CREATE OR REPLACE FUNCTION calculate_refund_amount(p_order_item_id BIGINT) 48 RETURNS DECIMAL(10,2) LANGUAGE plpgsql AS $$ 50 RETURNS DECIMAL(10,2) 51 LANGUAGE plpgsql 52 AS $$ 49 53 DECLARE 50 54 v_original_price DECIMAL(10,2); … … 75 79 76 80 CREATE OR REPLACE PROCEDURE buy_ticket(p_user_id BIGINT, p_ticket_id BIGINT) 77 LANGUAGE plpgsql AS $$ 81 LANGUAGE plpgsql 82 AS $$ 78 83 DECLARE 79 84 v_price DECIMAL(10,2); … … 111 116 112 117 CREATE OR REPLACE PROCEDURE cancel_ticket(p_order_item_id BIGINT, p_reason TEXT) 113 LANGUAGE plpgsql AS $$ 118 LANGUAGE plpgsql 119 AS $$ 114 120 DECLARE 115 121 v_refund_amount DECIMAL(10,2); … … 153 159 p_base_price DECIMAL(10,2) 154 160 ) 155 LANGUAGE plpgsql AS $$ 161 LANGUAGE plpgsql 162 AS $$ 156 163 DECLARE 157 164 v_happening_id BIGINT; … … 189 196 190 197 CREATE OR REPLACE PROCEDURE create_rating(p_user_id BIGINT, p_event_happening_id BIGINT, p_rating INT, p_comment TEXT) 191 LANGUAGE plpgsql AS $$ 198 LANGUAGE plpgsql 199 AS $$ 192 200 BEGIN 193 201 IF NOT EXISTS ( … … 221 229 222 230 CREATE OR REPLACE FUNCTION trg_check_user_age() 223 RETURNS TRIGGER LANGUAGE plpgsql AS $$ 231 RETURNS TRIGGER 232 LANGUAGE plpgsql 233 AS $$ 224 234 DECLARE 225 235 v_active BOOLEAN; … … 269 279 270 280 CREATE OR REPLACE FUNCTION trg_limit_tickets_per_happening() 271 RETURNS TRIGGER LANGUAGE plpgsql AS $$ 281 RETURNS TRIGGER 282 LANGUAGE plpgsql 283 AS $$ 272 284 DECLARE 273 285 v_happening_id BIGINT; … … 305 317 306 318 CREATE OR REPLACE FUNCTION trg_prevent_double_booking() 307 RETURNS TRIGGER LANGUAGE plpgsql AS $$ 319 RETURNS TRIGGER 320 LANGUAGE plpgsql 321 AS $$ 308 322 BEGIN 309 323 IF EXISTS (
