short sql question

From: goldgraeber-werbetechnik(at)t-online(dot)de
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: short sql question
Date: 2021-06-18 07:15:29
Message-ID: wolfgang-1210618091529.A0132500@linux-tuxedo
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


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 "from"

(Using PostgreSQL 10.4 on a NAS box)

Best regards
Wolfgang

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Georg H. 2021-06-18 11:31:19 Re: short sql question
Previous Message Laurenz Albe 2021-06-18 06:49:01 Re: A simple question about text fields