Re: SQL conversion help

From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
To: Ertan Küçükoğlu <ertan(dot)kucukoglu(at)1nar(dot)com(dot)tr>, pgsql-sql(at)postgresql(dot)org
Subject: Re: SQL conversion help
Date: 2017-05-20 04:07:40
Message-ID: 91052907-df30-2c98-a058-3f88dd204059@aklaver.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(dot)klaver(at)aklaver(dot)com

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Ertan Küçükoğlu 2017-05-20 13:24:37 Re: SQL conversion help
Previous Message Ertan Küçükoğlu 2017-05-20 04:01:41 SQL conversion help