From: John DeSoi <desoi@pgedit.com>
To: Duffy House <kevin07@optonline.net>
Cc: pgsql-sql@postgresql.org
Subject: Re: Moving from Transact SQL to PL/pgsql
Date: Tue, 25 Jan 2005 16:06:29 -0500
Message-ID: <FBA1DA04-6F14-11D9-BDFB-000A95B03262@pgedit.com> (raw)
In-Reply-To: <KKEKIFLFLKHPPMMMNLILKEKFCLAA.kevin07@optonline.net>
References: <KKEKIFLFLKHPPMMMNLILKEKFCLAA.kevin07@optonline.net>
On Jan 23, 2005, at 10:22 PM, Duffy House wrote:
> The first issue will be getting up to speed on PL/pgsql. Where can I
> find
> primer on PL/pgsql, with lots of examples? How silimar is PL/pgsql to
> PL/SQL
> under Oracle?
The PostgreSQL documentation is the place to start:
http://www.postgresql.org/docs/8.0/interactive/plpgsql.html
The PostgreSQL distribution has a file with some examples in it:
src/test/regress/sql/plpgsql.sql
The pgEdit distribution (http://pgedit.com/download) has a fairly
extensive plpgsql example for importing and analyzing web server logs.
I'm not familiar with Oracle, but there is a porting section in the
documentation:
http://www.postgresql.org/docs/8.0/interactive/plpgsql-porting.html
John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL
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: desoi@pgedit.com, kevin07@optonline.net
Subject: Re: Moving from Transact SQL to PL/pgsql
In-Reply-To: <FBA1DA04-6F14-11D9-BDFB-000A95B03262@pgedit.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