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 "
>> El día lunes, mayo 17, 2021 a las 01:27:40p. m. -, haman...@t-online.de
>> escribió:
>> >> > Hi,
>> > >> > in unicode letter ä exists in two versions - linux and windows use a
>> > >> > composite whereas macos prefers
>> > the decomposed form. Is there any way to make a semi-exact match th
Hi Gianni,
many thanks for your detailed response.
It turned out that my postgresql installation is too old for normalize,so I
will probably
a) use an external script to normalize existing data
b) change application code to normalize data before inserting or searching
Regards
Wolfgang
>> On 17
