From: | John DeSoi <desoi(at)pgedit(dot)com> |
---|---|
To: | Duffy House <kevin07(at)optonline(dot)net> |
Cc: | pgsql-sql(at)postgresql(dot)org |
Subject: | Re: Moving from Transact SQL to PL/pgsql |
Date: | 2005-01-25 21:06:29 |
Message-ID: | FBA1DA04-6F14-11D9-BDFB-000A95B03262@pgedit.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Franco Bruno Borghesi | 2005-01-26 00:12:18 | Re: update from multiple rows |
Previous Message | Thomas F.O'Connell | 2005-01-25 20:35:54 | Re: How to update dependent tables AND design considerations |