For Oracle info, check out one of my recent posts:
http://archives.postgresql.org/pgsql-sql/2005-01/msg00231.php
For TSQL, well, I was involved in project where we converted an Oracle db
(with procs, functions, triggers, etc) to PostgreSQL and MS Sql Server.
plpgsql and plsql are close enough whe
> ...
> Where can I find
> primer on PL/pgsql, with lots of examples?
> ...
Download openacs at http://openacs.org/projects/openacs/download/. Look at
directories matching
the pattern openacs-*/packages/*/sql/postgresql/. The older openacs version
4.6.3 has more
examples than openacs 5.
Ge
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
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
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 t
