Subject: Re: SQL conversion help
To: =?UTF-8?B?RXJ0YW4gS8O8w6fDvGtvxJ9sdQ==?= <ertan.kucukoglu@1nar.com.tr>,
 pgsql-sql@postgresql.org
References: <025d01d2d11d$cb2ebba0$618c32e0$@1nar.com.tr>
From: Adrian Klaver <adrian.klaver@aklaver.com>
Message-ID: <91052907-df30-2c98-a058-3f88dd204059@aklaver.com>
Date: Fri, 19 May 2017 21:07:40 -0700
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:52.0) Gecko/20100101
 Thunderbird/52.1.0
MIME-Version: 1.0
In-Reply-To: <025d01d2d11d$cb2ebba0$618c32e0$@1nar.com.tr>
Content-Type: text/plain; charset=windows-1254; format=flowed
Content-Language: en-US
Content-Transfer-Encoding: 8bit
Precedence: bulk
Sender: pgsql-sql-owner@postgresql.org

On 05/19/2017 09:01 PM, Ertan Küçükođlu wrote:
> 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
> SET @satirno = 0
> UPDATE urtrecetedet
> SET @satirno = satirno = @satirno + 1
> WHERE recetekodu = 'ASD'

I would suggest taking a look at:

https://www.postgresql.org/docs/9.6/static/plpgsql.html

In particular:

https://www.postgresql.org/docs/9.6/static/plpgsql-structure.html

https://www.postgresql.org/docs/9.6/static/plpgsql-declarations.html

https://www.postgresql.org/docs/9.6/static/plpgsql-statements.html

> 
> Thanks & regards,
> Ertan Küçükođlu
> 
> 
> 
> 
> 
> 
> 


-- 
Adrian Klaver
adrian.klaver@aklaver.com


-- 
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql