Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1dBvaZ-000810-HW for pgsql-sql@arkaria.postgresql.org; Sat, 20 May 2017 04:01:59 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1dBvaX-0005G4-VN for pgsql-sql@arkaria.postgresql.org; Sat, 20 May 2017 04:01:58 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1dBvaV-0005D4-Nt for pgsql-sql@postgresql.org; Sat, 20 May 2017 04:01:55 +0000 Received: from mta09.3.doruk.net.tr ([212.58.5.122] helo=mta09.doruk.net.tr) by makus.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1dBvaO-0006zS-EX for pgsql-sql@postgresql.org; Sat, 20 May 2017 04:01:54 +0000 Received: from cmail19.webkontrol.doruk.net.tr ([212.58.6.99]) by mta09.doruk.net.tr with esmtp (Exim 4.86) (envelope-from ) id 1dBvZM-000EAf-R6 for pgsql-sql@postgresql.org; Sat, 20 May 2017 07:00:44 +0300 Received: from DESKTOPM80CG12 ([176.233.185.222]) by cmail19.webkontrol.doruk.net.tr (IceWarp 11.1.2.0) with ASMTP id 201705200705257371 for ; Sat, 20 May 2017 07:05:25 +0300 From: =?iso-8859-9?B?RXJ0YW4gS/zn/Gtv8Gx1?= To: Subject: SQL conversion help Date: Sat, 20 May 2017 07:01:41 +0300 Message-ID: <025d01d2d11d$cb2ebba0$618c32e0$@1nar.com.tr> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-9" Content-Transfer-Encoding: quoted-printable X-Mailer: Microsoft Outlook 16.0 Content-Language: tr Thread-Index: AdLRHY0wy+pqMAf1RCSmBorsieVV1Q== X-Pg-Spam-Score: -0.7 (/) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-sql Precedence: bulk Sender: pgsql-sql-owner@postgresql.org Hello, I have below SQL script used in SQL Server. I would like some help to convert it into PostgreSQL format, please. DECLARE @satirno INT=20 SET @satirno =3D 0 UPDATE urtrecetedet SET @satirno =3D satirno =3D @satirno + 1 WHERE recetekodu =3D 'ASD' Thanks & regards, Ertan K=FC=E7=FCko=F0lu --=20 Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql