On Apr 17, 2008, at 12:26 PM, Mark Waser wrote:
Actually, it's far worse than that. For serious systems, most of the heavy lifting is done inside the database with stored procedures which are not standard AT ALL. SQL is reasonably easy to port. Stored procedures that do a lot of work are not.
The standard is SQL/PSM, which looks similar to Oracle's PL/SQL (and PostgreSQL's pl/pgsql). As a practical matter, support is not consistent enough or widespread enough for it to be entirely usable for purposes of portability though it is getting better.
To be fair, full SQL/PSM support will not be core in PostgreSQL until the next release.
J. Andrew Rogers ------------------------------------------- agi Archives: http://www.listbox.com/member/archive/303/=now RSS Feed: http://www.listbox.com/member/archive/rss/303/ Modify Your Subscription: http://www.listbox.com/member/?member_id=8660244&id_secret=101455710-f059c4 Powered by Listbox: http://www.listbox.com
