Re: PL/Java (was: stored procedures)

My DBA and I looked at the link on using SQL for stored procedures
(thanks Neil!) and he raised a couple concerns:

1. In the example given, the query is directed at just one table; he
says he needs to join multiple tables, and have it return a set. Can PG
do this?

2. The docs say this ability to return a set is deprecated and may be
removed in a future release. Why is that? Has this functionality been
replaced by something else (better?)

Sorry if these are really dumb questions. We're trying to use pg
(instead of O or SS) but we're new to it.

TIA
Petre

Neil Conway wrote:
http://pljava.sourceforge.net/

Interesting -- I did a quick search on sourceforge, but I guess it was a
bit too quick.

BTW, you can also write stored procedures in Ruby, C, and SQL.

I wasn't aware of Ruby, but I don't know how I could possibly have
forgotten to mention C and SQL!

I wonder if we shouldn't have a spot on techdocs with links to all of
the Postgres PLs all in one place? It makes for an impressive list; for
the record:

Available PostgreSQL Procedural Languages
==========================================
C
http://www.us.postgresql.org/users-lounge/docs/7.3/postgres/xfunc-c.html

SQL
http://www.us.postgresql.org/users-lounge/docs/7.3/postgres/xfunc-sql.html

PL/pgSQL
http://www.us.postgresql.org/users-lounge/docs/7.3/postgres/plpgsql.html

PL/Perl
http://www.us.postgresql.org/users-lounge/docs/7.3/postgres/plperl.html

PL/Tcl
http://www.us.postgresql.org/users-lounge/docs/7.3/postgres/pltcl.html

PL/Python
http://www.us.postgresql.org/users-lounge/docs/7.3/postgres/plpython.html

PL/sh
http://webmail.postgresql.org/~petere/plsh.html

PL/R
http://www.joeconway.com/plr/

PL/Java
http://pljava.sourceforge.net/

PL/Ruby
http://raa.ruby-lang.org/list.rhtml?name=pl-ruby

==========================================

Joe

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html