diff options
| author | Masaya Tojo <masaya@tojo.tokyo> | 2023-03-27 04:01:47 +0900 |
|---|---|---|
| committer | Masaya Tojo <masaya@tojo.tokyo> | 2023-03-27 04:01:47 +0900 |
| commit | 6b8ab6fe190e9d8f42242ff1f57be8c28e9ca066 (patch) | |
| tree | f608d39d4f2a33652aba5ebc00d705d1d14ccd88 /deploy/delete_item.sql | |
| parent | 0a8e2a6e5dc7d75017f81d90ce1eb904280f1cba (diff) | |
Delete insert/delete functions.
Diffstat (limited to 'deploy/delete_item.sql')
| -rw-r--r-- | deploy/delete_item.sql | 15 |
1 files changed, 0 insertions, 15 deletions
diff --git a/deploy/delete_item.sql b/deploy/delete_item.sql deleted file mode 100644 index 38b3083..0000000 --- a/deploy/delete_item.sql +++ /dev/null @@ -1,15 +0,0 @@ --- Deploy kakeibo:delete_item to pg --- requires: schema --- requires: items - -BEGIN; - -CREATE OR REPLACE FUNCTION kakeibo.delete_item( - p_item_id INTEGER -) RETURNS VOID AS $$ - BEGIN - DELETE FROM kakeibo.items WHERE id = p_item_id; - END; -$$ LANGUAGE plpgsql SECURITY DEFINER; - -COMMIT; |