On 10/19/22 12:48, Mark Raynsford wrote:
> On 2022-10-19T12:43:31 -0700
> Adrian Klaver <adrian.klaver@aklaver.com> wrote:
>>
>> HINT: There is an entry for table "t", but it cannot be referenced from
>> this part of the query.
>>
>> HINT: There is a column named "x" in table "t", but it cannot be
>> referenced from this part of the query.
>
> Yes, I saw those, hence asking on the list if there was a way to do it.
Using a trigger.
>
> I'll handle it with multiple statements.
>
--
Adrian Klaver
adrian.klaver@aklaver.com