Re: Moving to PostGres

"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