You don't need to use PL/Java - you can call the SPI functions
through standard SQL. I have C functions that return tuples and call
them with executeQuery(...).
The function in question is defined as
CREATE TYPE correlation_type AS
CREATE OR REPLACE FUNCTION
RETURNS SETOF correlation_type
LANGUAGE 'C' STABLE STRICT;
and then I call it with
ResultSet results = st
.executeQuery("SELECT * FROM
and work through the result set.
Katsaros Kwn/nos wrote:
>I'm new to PostgreSQL with JDBC. What I want to do is to connect an
>already implemented Java application to my postgresql server.I want to
>be able to pass arguments from the java application to some function
>I've written in C (that uses SPI functions) and receive tuples to
>display in the Java GUI.
>Any hints on where to start from?
>Richard Huxton at the General list kindly pointed me to the PL/Java
>project. Is this where I should focus?
>Thanks in advance,
>---------------------------(end of broadcast)---------------------------
>TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org
In response to
pgsql-jdbc by date
|Next:||From: Oliver Jowett||Date: 2004-09-30 21:55:14|
|Subject: Re: Remote query very slow|
|Previous:||From: Katsaros Kwn/nos||Date: 2004-09-30 12:16:44|
|Subject: Java app and SPI functions|