Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1aq642-00071E-Ji for pgsql-admin@arkaria.postgresql.org; Tue, 12 Apr 2016 21:41:38 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1aq642-00054E-6k for pgsql-admin@arkaria.postgresql.org; Tue, 12 Apr 2016 21:41:38 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1aq62L-0001uV-KX for pgsql-admin@postgresql.org; Tue, 12 Apr 2016 21:39:53 +0000 Received: from blu004-omc2s37.hotmail.com ([65.55.111.112]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1aq62I-0004Mt-57 for pgsql-admin@postgresql.org; Tue, 12 Apr 2016 21:39:53 +0000 Received: from BLU437-SMTP8 ([65.55.111.73]) by BLU004-OMC2S37.hotmail.com over TLS secured channel with Microsoft SMTPSVC(7.5.7601.23008); Tue, 12 Apr 2016 14:39:48 -0700 X-TMN: [gWsP/MpQ4VDdR9WL/qqQ34ZuxBQKz9rj] X-Originating-Email: [koff10@hotmail.com] Message-ID: Subject: Re: upsert example about postgres9.5 To: gilberto.castillo@etecsa.cu References: <58935.192.168.207.54.1460496234.squirrel@webmail.etecsa.cu> CC: pgsql-admin@postgresql.org From: koff10 Date: Tue, 12 Apr 2016 23:39:46 +0200 User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:38.0) Gecko/20100101 Thunderbird/38.7.0 MIME-Version: 1.0 In-Reply-To: <58935.192.168.207.54.1460496234.squirrel@webmail.etecsa.cu> Content-Type: text/plain; charset="utf-8"; format=flowed Content-Transfer-Encoding: quoted-printable X-OriginalArrivalTime: 12 Apr 2016 21:39:46.0234 (UTC) FILETIME=[D50DB1A0:01D19503] X-Pg-Spam-Score: -3.4 (---) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org Thanks for your reply. So there is no Sql instruction like UPSERT ! koff. Le 12/04/2016 23:23, Gilberto Castillo a =C3=A9crit : >> 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 =3D accesos_usuarios.accesos + EXCLUDED.accesos; > > insert into accesos_usuarios (usuarios, accesos) > values ('8kdata',1), ('8kdata2',1) > on conflict do nothing; > > Tomado de un presentaci=C3=B3n de Alvaro Hernadez En Cuba > --=20 Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin