Sherwin Daganato wrote:
On Mon, Aug 18, 2003 at 10:56:27AM +0800, Ariz Jacinto wrote:
all i can say is that using the plain PL/pgSQL can make your
UDFs/Procs easily portable to other db servers (supporting
ANSI SQL 9?) without the overhead of scripting engines.
... as long as those db servers are running PostgreSQL. :-)
FROM http://www.postgresql.org/docs/7.3/static/plpgsql.html:
19.1.1.3. Portability Because PL/pgSQL functions run inside PostgreSQL, these functions will run on any platform where PostgreSQL runs. Thus you can reuse code and reduce development costs.
i was referring to pl/pgsql's partly conformance to SQL99 standard. which makes pl/pgsql-based proc portablity to other DB servers complying with the same std such as Oracle (PL/SQL), MySQL 5, IB, MSSQL, etc. =)
1. The SQL99 standard is also split into 5 parts: .... part 4 is similar to the PL/pgSQL programming language, but exact conformance is not specifically intended in either case.
http://www.postgresql.org/docs/7.3/interactive/features.html
2. PL/pgSQL is similar to PL/SQL in many aspects. It is a block structured,
imperative language (all variables have to be declared). PL/SQL has many
more features than its PostgreSQL counterpart, but PL/pgSQL allows for
a great deal of functionality and it is being improved constantly.
http://www.postgresql.org/docs/7.3/static/plpgsql-porting.html
[ Misc ]
3. MySQL Stored procedures are currently being implemented. This effort is based on SQL-99,
which has a basic syntax similar (but not identical) to Oracle PL/SQL. We will also
implement the SQL-99 framework to hook in external languages, and (where possible)
compatibility with, for example, PL/SQL and T-SQL.
http://www.mysql.com/doc/en/TODO_MySQL_5.0.html
-- Philippine Linux Users' Group (PLUG) Mailing List [EMAIL PROTECTED] (#PLUG @ irc.free.net.ph) Official Website: http://plug.linux.org.ph Searchable Archives: http://marc.free.net.ph . To leave, go to http://lists.q-linux.com/mailman/listinfo/plug . Are you a Linux newbie? To join the newbie list, go to http://lists.q-linux.com/mailman/listinfo/ph-linux-newbie
