clear markdown compare help donate or buy diddy dollings comments/suggestions/bugs a leap of faith? bible365
clear markdown donate comments/suggestions/bugs a leap of faith? bible365 diddy dollings
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0. 635708 fiddles created (13341 in the last week).

CREATE TABLE tablefindold ( hostname character varying(16) not null primary key, lastmiss timestamp without time zone, lastfind timestamp without time zone, uname character varying(64) );
 hidden batch(es)


INSERT INTO tableFindOld(hostname, lastMiss, lastFind, uname) VALUES('pcname', DEFAULT, '2019-03-04 11:38:04', 'billy') ON CONFLICT (tablefindold.hostname) DO UPDATE SET lastFind='2019-03-04 11:38:04', uname='billy' WHERE tableFindOld.hostname='pcname';
ERROR: syntax error at or near ")" LINE 3: ON CONFLICT (tablefindold.hostname) ^
 hidden batch(es)


INSERT INTO tableFindOld(hostname, lastMiss, lastFind, uname) VALUES('pcname', DEFAULT, '2019-03-04 11:38:04', 'billy') ON CONFLICT (hostname) DO UPDATE SET lastFind='2019-03-04 11:38:04', uname='billy' WHERE tableFindOld.hostname='pcname';
1 rows affected
 hidden batch(es)