From: | koff10 <koff10(at)hotmail(dot)com> |
---|---|
To: | gilberto(dot)castillo(at)etecsa(dot)cu |
Cc: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: upsert example about postgres9.5 |
Date: | 2016-04-12 21:39:46 |
Message-ID: | BLU437-SMTP8F617F3039AAF88CEF289CA950@phx.gbl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Thanks for your reply.
So there is no Sql instruction like UPSERT !
koff.
Le 12/04/2016 23:23, Gilberto Castillo a écrit :
>> Hi all,
>>
>> It's known that postgres 9.5 has introduce upsert instruction.
>> Is somebody can show me how to use this instruction ?
>> Do the UPSERT commande exists in SQL ?
>>
>
> insert into accesos_usuarios (usuarios, accesos)
> values ('8kdata',1)
> on conflict (usuarios)
> do update set
> accesos = accesos_usuarios.accesos + EXCLUDED.accesos;
>
> insert into accesos_usuarios (usuarios, accesos)
> values ('8kdata',1), ('8kdata2',1)
> on conflict do nothing;
>
> Tomado de un presentación de Alvaro Hernadez En Cuba
>
From | Date | Subject | |
---|---|---|---|
Next Message | Bryan Ward | 2016-04-12 22:02:56 | Postgresql 9.0.23 - checkpoint delays |
Previous Message | Gilberto Castillo | 2016-04-12 21:23:54 | Re: upsert example about postgres9.5 |