Re: Dynamically accessing columns from a row type in a trigger

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: "Rhys A(dot)D(dot) Stewart" <rhys(dot)stewart(at)gmail(dot)com>
Cc: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Dynamically accessing columns from a row type in a trigger
Date: 2023-08-13 04:34:59
Message-ID: CAKFQuwZzjY5mp4CpfLJb3DpfijyKxJ4Eki7ezidGR-OYkuHhCg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Sat, Aug 12, 2023 at 1:10 PM Rhys A.D. Stewart <rhys(dot)stewart(at)gmail(dot)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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message jian he 2023-08-13 04:53:56 Re: Dynamically accessing columns from a row type in a trigger
Previous Message Adrian Klaver 2023-08-13 04:28:10 Re: Dynamically accessing columns from a row type in a trigger