Postgres Pro
Downloads
Home   >   mailing lists

Re: Dynamically accessing columns from a row type in a trigger - Mailing list pgsql-general

From David G. Johnston
Subject Re: Dynamically accessing columns from a row type in a trigger
Date
Msg-id CAKFQuwZzjY5mp4CpfLJb3DpfijyKxJ4Eki7ezidGR-OYkuHhCg@mail.gmail.com
Whole thread Raw
In response to Dynamically accessing columns from a row type in a trigger  ("Rhys A.D. Stewart" <rhys.stewart@gmail.com>)
List pgsql-general
Tree view
On Sat, Aug 12, 2023 at 1:10 PM Rhys A.D. Stewart <rhys.stewart@gmail.com> wrote:
Am I missing out on a simpler or more elegant solution?


No, you are not (at least among SQL and pl/pgsql.  SQL is strongly and statically typed.  Circumventing that has a cost, but at least you do have tools at hand when you find the need.

David J.

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Dynamically accessing columns from a row type in a trigger
Next
From: jian he
Date:
Subject: Re: Dynamically accessing columns from a row type in a trigger