Re: Moving from Transact SQL to PL/pgSQL

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: Kevin Duffy <kevin07(at)parkerglobal(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Moving from Transact SQL to PL/pgSQL
Date: 2005-01-25 19:19:38
Message-ID: 20050125191937.GA78285@winnie.fuhr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On Mon, Jan 24, 2005 at 12:14:22PM -0500, Kevin Duffy wrote:

> Where would I find documentation on PL/pgSQL, with examples?

On the PostgreSQL web site, or perhaps on your own server if you've
installed the documentation.

http://www.postgresql.org/

Follow the "Documentation" link, then follow the "Online Manuals"
link for whatever version of PostgreSQL you're running. The PL/pgSQL
documentation is under "Server Programming."

> How close to Oracle PL-SQL is Postgres? Would a Oracle PL-SQL book cover the basics?

The PL/pgSQL documentation has a "Porting from Oracle PL/SQL"
section.

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Dennis Sacks 2005-01-25 20:19:38 Re: Moving from Transact SQL to PL/pgSQL
Previous Message Michael Fuhr 2005-01-25 19:10:45 Re: Looking up table names by REFERENCES