On 8/15/07, Magnus Hagander <magnus@xxxxxxxxxxxx> wrote: > Trevor Talbot wrote: > > On 8/14/07, Jasbinder Singh Bali <jsbali@xxxxxxxxx> wrote: > > > >> Let me fine tune my question here. What I mean to say is the way we can > >> write stored procedures in C, perl etc in Postgres specifying the language > >> parameter at the end of stored procedure, compared to that, in SQL Server > >> 2000 I've seen SP writing in pure SQL only. > >> Can you write Stored Procedures in SQL Server 2000 or Oracle in different > >> programing languages as well ? > > > > AFAIK SQL Server 2000 only has a C interface as the other option; CLR > > hosting was added in SQL Server 2005. Because the CLR is a virtual > > machine that runs compiled bytecode, and compilers for all of the > > available languages are not necessarily available at runtime, it > > doesn't make sense to specify such code in source form. The process > > is more like creating a function in C in PostgreSQL (compile and load > > a shared library). Details here, if you're curious: > > http://msdn2.microsoft.com/en-us/library/ms345136.aspx > > > > I don't know what Oracle supports. > > I believe Oracle support Java in the same way MSSQL supports .net, give > or take. I don't know specifics of what exactly you can do with it nor how exactly you go about it, but I know at least Oracle 10g supports extension in Java. We had grand plans to improve some sort of processing by writing a comparison function in Java for one the Oracle databases I've been cursed to associate with. I don't know of any other languages supported by Oracle for stored procedures and the like, though it does have an ECPG-like system for C, C++, COBOL, FORTRAN, and PL/1 of all things. - Josh - Josh ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
