By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
464,514 Members | 836 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 464,514 IT Pros & Developers. It's quick & easy.

Stored procedures in PL/PGSQL

P: n/a
FET
Hello,
I am in a bit of a conflict here. I would like to know if the stored
procedures that I write in PL/PGSQL to run on PostgreSQL 7.4.2 are
ANSI compliant. The point of asking this question is whether my stored
procedure needs to undergo a lot of change if I port it to some other
database like Oracle or MSSQL Server.

Thank you in advance,

Best regards.
Jul 19 '05 #1
Share this Question
Share on Google+
2 Replies

P: n/a
Stu
The logic won't change, but the syntax will. It's kind of like asking, "if
I write a program in C++ will it be easy to port to Java?" PL/PGSQL is a
language, different vendors use different languages--MS SQL Server and
Sybase use Transact-SQL (they have a shared history, that's why they use
the same language), Oracle uses PL/SQL, Firebird uses PSQL, etc.

As for ANSI compliant, ANSI added Persistent Stored Modules (SQL/PSM) in
SQL99, to address the portability issue, but I don't think any vendor has
done a complete implementation of it yet.
Stu
FET wrote:
Hello,
I am in a bit of a conflict here. I would like to know if the stored
procedures that I write in PL/PGSQL to run on PostgreSQL 7.4.2 are
ANSI compliant. The point of asking this question is whether my stored
procedure needs to undergo a lot of change if I port it to some other
database like Oracle or MSSQL Server.

Thank you in advance,

Best regards.


Jul 19 '05 #2

P: n/a
bi**********@yahoo.com (FET) wrote:
Hello,
I am in a bit of a conflict here. I would like to know if the stored
procedures that I write in PL/PGSQL to run on PostgreSQL 7.4.2 are
ANSI compliant. The point of asking this question is whether my stored
procedure needs to undergo a lot of change if I port it to some other
database like Oracle or MSSQL Server.


NO system supports an "ANSI compliant" stored procedure language at
this point in time. Not PostgreSQL, not Oracle, not Microsoft SQL
Server.

It seems likely that a project may emerge in 7.6 or so to build one,
but in view of there not being _any_ compliant system, it hasn't
emerged as a priority.
--
wm(X,Y):-write(X),write('@'),write(Y). wm('cbbrowne','acm.org').
http://www.ntlug.org/~cbbrowne/x.html
Rules of the Evil Overlord #10. "I will not interrogate my enemies in
the inner sanctum -- a small hotel well outside my borders will work
just as well." <http://www.eviloverlord.com/>
Jul 19 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.