Re: Moving to PostGres

From: Neil Conway <neilc(at)samurai(dot)com>
To: "Benjamin Stewart" <bstewart(at)waterwerks(dot)com(dot)au>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Moving to PostGres
Date: 2002-10-07 16:18:46
Message-ID: 87it0eql21.fsf@mailbox.samurai.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs pgsql-hackers

"Benjamin Stewart" <bstewart(at)NOSPAM(dot)waterwerks(dot)com(dot)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(at)samurai(dot)com> || PGP Key ID: DB3C29FC

In response to

Browse pgsql-docs by date

  From Date Subject
Next Message Vince Vielhaber 2002-10-07 16:20:37 reminder for those working on docs
Previous Message ellis 2002-10-07 02:37:08 Re: Moving to PostGres

Browse pgsql-hackers by date

  From Date Subject
Next Message Greg Copeland 2002-10-07 16:20:21 Re: Proposed LogWriter Scheme, WAS: Potential Large
Previous Message Zeugswetter Andreas SB SD 2002-10-07 15:42:12 Re: [HACKERS] Large databases, performance