Re:Easy, alternative soft deletion: `deleted_record_insert`
by simcop2387 on Sunday January 01, 2023 @07:41AM
(#34205848)
I haven't tested it but it might be the case that it'd need to be a stored generated column to be referenced like that but that shouldn't be a big deal.
As an aside, they’re a great feature. We’re using them to generate columns that we can index for efficient joins between tables and also for creating text strings for searching over using trigram indexes. The whole thing is really seamless.