Re: Column value derived from generated column in INSERT?

From: Mark Raynsford <co+org(dot)postgresql(at)io7m(dot)com>
To: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
Cc: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>, pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Column value derived from generated column in INSERT?
Date: 2022-10-19 19:48:05
Message-ID: 20221019194805.79d0b2ed@sunflower.int.arc7.info
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 2022-10-19T12:43:31 -0700
Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)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.

I'll handle it with multiple statements.

--
Mark Raynsford | https://www.io7m.com

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2022-10-19 19:58:35 Re: Column value derived from generated column in INSERT?
Previous Message Adrian Klaver 2022-10-19 19:43:31 Re: Column value derived from generated column in INSERT?