Re: Column value derived from generated column in INSERT?

2022-10-19 Thread Mark Raynsford
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

Re: Column value derived from generated column in INSERT?

2022-10-19 Thread Mark Raynsford
On 2022-10-19T11:58:07 -0700 "David G. Johnston" wrote: > On Wed, Oct 19, 2022 at 10:36 AM Mark Raynsford > wrote: > > > insert into t (y) values (t.x * 2); > > > > I can think of various ways to do it with multiple statements, but a > > single st

Column value derived from generated column in INSERT?

2022-10-19 Thread Mark Raynsford
with multiple statements, but a single statement would be preferable. -- Mark Raynsford | https://www.io7m.com