<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<div class="moz-cite-prefix">On 19/05/2019 16:25, John Fawcett via
dovecot wrote:<br>
</div>
<blockquote type="cite"
cite="mid:e87cc202-4d01-18d8-eba3-7591debcf0ec@voipsupport.it">
<pre class="moz-quote-pre" wrap="">INSERT INTO last_logins (last_login,username,domain) VALUES (1558273000,'<a class="moz-txt-link-abbreviated" href="mailto:user@domain.tld" moz-do-not-send="true">user@domain.tld</a>','domain.tld')
</pre>
</blockquote>
<pre class="moz-quote-pre" wrap="">I don't have PostgresSql, would you be able to verify if this syntax would work:
INSERT INTO last_logins (last_login,username,domain) VALUES (1558273000,'<a class="moz-txt-link-abbreviated" href="mailto:user@domain.tld">user@domain.tld</a>','domain.tld') <span class="crayon-r">ON</span><span class="crayon-h"> </span>CONFLICT<span class="crayon-h"> </span>(<span class="crayon-r">username</span>) <span class="crayon-h">UPDATE SET last_login=</span>1558273000,domain='<a class="moz-txt-link-abbreviated" href="mailto:user@domain.tld">user@domain.tld</a>'
It's important to check that this updates only the single row for that user and it puts the right data in that row. If it doesn't work can you give the correct syntax?
John
</pre>
<pre class="moz-quote-pre" wrap="">
</pre>
</body>
</html>