Accessing values in anonymous row types in Postgres
If you are trying to build pivot tables in Postgres, you may find examples online that incorrectly push you towards using the “ROW” type to build the pivot table. You might try something like the following (which will not work):