Re: [SQL] SQL conversion help - Mailing list pgsql-sql

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