comics
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
bag_and_board(bag character, board character, comics character[])
Parameters
Name
Type
Mode
bag
character
IN
board
character
IN
comics
character[]
IN
Definition
DECLARE comic char(4); BEGIN FOREACH comic IN ARRAY comics LOOP INSERT INTO comic_bag_board (comic_id, bag_id, bag_date, board_id, board_date) VALUES (comic, bag, current_date, board, current_date) ON CONFLICT (comic_id) DO UPDATE SET bag_id = bag, bag_date = current_date, board_id = board, board_date = current_date; END LOOP; END;