Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id CEDA2475F4F for ; Mon, 7 Oct 2002 12:19:03 -0400 (EDT) Received: from bob.samurai.com (bob.samurai.com [205.207.28.75]) by postgresql.org (Postfix) with ESMTP id 29E42475E8A for ; Mon, 7 Oct 2002 12:19:03 -0400 (EDT) Received: from boston.samurai.com (DU179.N224.ResNet.QueensU.CA [130.15.224.179]) by bob.samurai.com (Postfix) with ESMTP id B20401E12; Mon, 7 Oct 2002 12:19:07 -0400 (EDT) To: "Benjamin Stewart" Cc: pgsql-hackers@postgresql.org Subject: Re: Moving to PostGres References: From: Neil Conway In-Reply-To: Date: 07 Oct 2002 12:18:46 -0400 Message-ID: <87it0eql21.fsf@mailbox.samurai.com> Lines: 22 User-Agent: Gnus/5.09 (Gnus v5.9.0) Emacs/21.2 MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200210/389 X-Sequence-Number: 30158 "Benjamin Stewart" writes: > 1. What is the postgresql equiv to Stored procedures and can they be written > in another langauage such s JAVA? PostgreSQL supports user-defined functions; in 7.3 (currently in beta) they can return sets of tuples. You can define functions in Java using http://pljava.sf.net , or in a variety of other languages (Perl, Python, Tcl, Ruby, C, PL/PgSQL, SQL, sh, etc.) > 2. How well is JAva supported for developing DB applications using > PG? "Pretty well", I guess. If you have a specific question, ask it. Cheers, Neil -- Neil Conway || PGP Key ID: DB3C29FC