where it isn't too hard to convert
between the two. TSQL and plpgsql are quite different.
-Clint
Original Message Follows
From: "Kevin Duffy" <[EMAIL PROTECTED]>
To:
Subject: [SQL] Moving from Transact SQL to PL/pgSQL
Date: Mon, 24 Jan 2005 12:14:22 -0500
Hello:
I
> ...
> 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
Hello:
I am implementing a new system using Postgres. Well most of the system will
be new,
but some parts will be very similar to a system currently running under
M$-SQL.
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 s
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 c
