short sql question

Hi, I just cannot see what is wrong with my query: create table files (id int, name text, prev_name text, ); create table fnchanged (id int, name text); update files f set prev_name = f.name, name = c.name from fnchanges c where f.id = c.id and c.name != f.name --- gets syntax error at "

Re: short sql question

Hi, Am 18.06.2021 um 09:15 schrieb goldgraeber-werbetech...@t-online.de: Hi, I just cannot see what is wrong with my query: create table files (id int, name text, prev_name text, ); create table fnchanged (id int, name text); update files f set prev_name = f.name, name = c.name from fncha

Re: Temporal tables as part of main release

On 6/17/21 11:10 PM, David G. Johnston wrote: And, since its not in the commitfest app, and the last emails I found are over a year old, it doesn’t seem to be a priority for anyone at this time. I'm working on the application-time (aka valid-time) side of this, and there is another patch for