logic-procedures

SKILL.md

Encapsulate complex business logic within the database using Stored Procedures and Functions to ensure consistency, reducing round-trips and enforcing data integrity closer to the source.

2.1 Standard Header & idempotent Creation Always use CREATE OR REPLACE to allow easy redeployment. Include a standard header block.

3.1 Error Handling Use EXCEPTION blocks to handle errors gracefully or re-raise them with context. Standardize error messages.

PL/pgSQL 業務邏輯過程和最佳實踐觸發器：編寫存儲過程或數據庫邏輯時。 來源：poletron/custom-rules。

查看原文