Re: Moving to PostGres - Mailing list pgsql-hackers

From Neil Conway
Subject Re: Moving to PostGres
Date
Msg-id 87it0eql21.fsf@mailbox.samurai.com
Whole thread Raw
In response to Moving to PostGres  ("Benjamin Stewart" <bstewart@NOSPAM.waterwerks.com.au>)
List pgsql-hackers
"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



pgsql-hackers by date:

Previous
From: "Zeugswetter Andreas SB SD"
Date:
Subject: Re: [GENERAL] Large databases, performance
Next
From: Greg Copeland
Date:
Subject: Re: Proposed LogWriter Scheme, WAS: Potential Large