You're right! My mistake. I was thinking of statement triggers. https://www.post... | Hacker News

Hacker News new | past | comments | ask | show | jobs | submit

login

samanator on April 9, 2023 | parent | context | favorite | on: PL/Rust 1.0: now a trusted language for Postgres

You're right! My mistake. I was thinking of statement triggers.

https://www.postgresql.org/docs/current/sql-createtrigger.ht...

> The REFERENCING option enables collection of transition relations

I don't see any examples of statement triggers...

ttfkam on April 10, 2023 [–]

https://stackoverflow.com/a/72397774

Note the use of new_table and old_table as aliases. Instead of single records in NEW and OLD, you can select against new and old sets of records.

samanator on April 12, 2023 | [–]

I understand, and I've used the old and new table aliases. But I meant that I don't see a way to use those in the PL/Rust docs.

Join us for AI Startup School this June 16-17 in San Francisco!
Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact