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
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 |