Re: Column value derived from generated column in INSERT? - Mailing list pgsql-general

From Adrian Klaver
Subject Re: Column value derived from generated column in INSERT?
Date
Msg-id 507b68d6-db0d-6cc5-f9d3-2dbd7bc8ad97@aklaver.com
Whole thread Raw
In response to Re: Column value derived from generated column in INSERT?  (Mark Raynsford <co+org.postgresql@io7m.com>)
Responses Re: Column value derived from generated column in INSERT?
List pgsql-general
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




pgsql-general by date:

Previous
From: Mark Raynsford
Date:
Subject: Re: Column value derived from generated column in INSERT?
Next
From: Bryn Llewellyn
Date:
Subject: Re: COMMIT IN STORED PROCEDURE WHILE IN A LOOP