I have a trigger that is attached to several different tables. In the trigger function I retrieve a single row and I want the info from a specific column. This column is dependent on the table in question.
The only workaround I can think of is to wrap the query that populates the record variable in a to_jsonb function and then subscript that.
Is there a better way?
Not in the strongly typed language that is SQL; you will be unable to use first-tier types in that way. You indeed need to create a type that itself is dynamic in terms of the information it stores (jsonb works) which also involves throwing away the static typing of the outer layer and devolving everything to basically text.
