Received: from localhost (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP
	id 78D904762EC; Sun,  6 Oct 2002 22:09:39 -0400 (EDT)
Received: from news.hub.org (news.hub.org [64.49.215.80])
	by postgresql.org (Postfix) with ESMTP
	id 1772C476272; Sun,  6 Oct 2002 22:09:39 -0400 (EDT)
Received: by news.hub.org (Postfix, from userid 8)
	id CA4ED381810; Sun,  6 Oct 2002 22:09:37 -0400 (EDT)
From: "Benjamin Stewart" <bstewart@NOSPAM.waterwerks.com.au>
X-Newsgroups: comp.databases.postgresql.docs,
 comp.databases.postgresql.hackers,
	linux.postgres
Subject: Moving to PostGres
Lines: 13
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2600.0000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
Message-ID: <XU5o9.11017$vg.28049@news-server.bigpond.net.au>
Date: Mon, 07 Oct 2002 02:00:23 GMT
X-Complaints-To: news@bigpond.net.au
Organization: BigPond Internet Services (http://www.bigpond.net.au)
To: pgsql-hackers@postgresql.org, pgsql-docs@postgresql.org
X-Virus-Scanned: by AMaViS new-20020517
X-Archive-Number: 200210/2
X-Sequence-Number: 1496

Hello,
I am looking at moving our company away from MS SQL. Have been looking at
DB2 and it looks to have some good features. Now wondering if POSTGRESQL
could be a viable alternative. I have a few questions though;
1. What is the postgresql equiv to Stored procedures and can they be written
in another langauage such s JAVA?
2. How well is JAva supported for developing DB applications using PG?
3. What are the limitations to PG compared to DB2, Oracle, Sybase ?

Thanks
Ben