On Mon, Aug 18, 2003 at 04:17:39PM +0800, 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. :-)
The closest that you'll ever get to "portability" in db languages is going from Sybase to Microsoft SQL Server, which share a common ancestry and both use a dialect of "Transact-SQL". Other than that, PL/pgSQL is similar to PL/SQL. There's never been a real standard for the stored procedure languages, everybody made up their own. Michael -- Michael Darrin Chaney [EMAIL PROTECTED] http://www.michaelchaney.com/ -- 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
