Thread: Moving to PostGres

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

In article <XU5o9.11017$vg.28049@news-server.bigpond.net.au>,
Benjamin Stewart <bstewart@NOSPAM.waterwerks.com.au> wrote:

>I am looking at moving our company away from MS SQL.


Here's a good place to start:

  http://techdocs.postgresql.org/redir.php?link=/techdocs/sqlserver2pgsql.php

--
http://www.spinics.net/linux/

"Benjamin Stewart" <bstewart@NOSPAM.waterwerks.com.au> 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 <neilc@samurai.com> || PGP Key ID: DB3C29FC