Re: PLPGSQL - extra column existence in trigger

Dear David!

That was a very good idea! I have integrated it! :-)

Priorly I had another idea: I made a DDL to extend the table with "add
column if not exists" elements.
But what you suggested is better. Thank you!

Best wishes
dd

David G. Johnston <david(dot)g(dot)johnston(at)gmail(dot)com> ezt írta (időpont: 2022.
máj. 7., Szo, 16:41):

> On Saturday, May 7, 2022, Durumdara <durumdara(at)gmail(dot)com> wrote:
>
>>
>>
>> So is there any syntax to not fall on missing columns?
>>
>
> No. I’d probably approach this by generically converting the NEW record
> to json and working with that. Non-existent object keys return null when
> accessed.
>
> David J.
>