From: Dennis Sacks <dennis@illusions.com>
To: pgsql-sql@postgresql.org
Subject: Re: Moving from Transact SQL to PL/pgSQL
Date: Tue, 25 Jan 2005 13:19:38 -0700
Message-ID: <41F6A9DA.20500@illusions.com> (raw)
In-Reply-To: <AD00BDEBE7882B4E931CCE42D291A88F7880DE@mail04.CONNECT.CONNECTAPPS.NET>
References: <AD00BDEBE7882B4E931CCE42D291A88F7880DE@mail04.CONNECT.CONNECTAPPS.NET>
Kevin Duffy wrote:
> Hello:
>
> I am starting a project using Postgres. The requirements are very
> similar to work I have done in the past using M$-SQL. Therefore,
> there are many Transact SQL stored procedures I need to port over to
> PL/pgSQL.
>
> Where would I find documentation on PL/pgSQL, with examples?
>
> How close to Oracle PL-SQL is Postgres? Would a Oracle PL-SQL book
> cover the basics?
>
Oracle PL-SQL and PL/pgSQL seem very similar. There are definitely
differences however. Most of what you want to know is included in the
PostgreSQL document. I'd recommend reading through the PL/pgSQL chapter
several times before you begin.
_PostgreSQL_ by Douglas and Douglas has a chapter on PL/pgSQL. I'm not
sure what that chapter is like as I don't own this book. It might be
worth looking into.
I don't know of any documents that give hints for porting from TSQL to
PL/pgSQL, but then I've not looked for any. They may exist.
Best of luck,
Dennis Sacks
dennis@illusions.com
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: dennis@illusions.com
Subject: Re: Moving from Transact SQL to PL/pgSQL
In-Reply-To: <41F6A9DA.20500@illusions.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox