News for hackers. Stuff that matters.

A comment on /story/44490510. Parent comment

Re: by candiddevmike on Thursday July 10, 2025 @08:17PM (#44527147)
I don't follow how you would do that in a stored procedure outside of a trigger.
[ Parent | on HN ]
Re: by const_cast on Thursday July 10, 2025 @09:27PM (#44527554)
I think instead of performing an INSERT you call a stored proc that does the insert and some extra stuff.
[ Parent | on HN ]
Re: by shivasaxena on Friday July 11, 2025 @01:48PM (#44535087)
Yes, we already have all of our business logic in postgres functions(create_order, create_partial_payment etc).

Doing the extra work in stored procedures is noticeably faster than relying on triggers.

[ Parent | on HN ]