call syntax for record returning stored function

From: markw(at)osdl(dot)org
To: pgsql-jdbc(at)postgresql(dot)org
Subject: call syntax for record returning stored function
Date: 2004-03-22 18:00:19
Message-ID: 200403221800.i2MI0iE07396@mail.osdl.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

I'm having a little trouble figuring out the call syntax for calling a
pl/pgsql stored function that returns a record with
Connection.prepareCall(). I'm not getting the column definition list
correct. A pointer to an example would be great, or an example for
something like the following:

CREATE OR REPLACE FUNCTION home (INTEGER, INTEGER)
RETURNS RECORD AS '
DECLARE
c_fname CHAR(15);
pp_i_id1 INTEGER;
rec RECORD;
BEGIN
...
SELECT c_fname::CHAR(15), pp_i_id1::INTEGER
INTO rec;
RETURN rec;
END;
' LANGUAGE 'plpgsql';

Thanks!
--
Mark Wong - - markw(at)osdl(dot)org
Open Source Development Lab Inc - A non-profit corporation
12725 SW Millikan Way - Suite 400 - Beaverton, OR 97005
(503) 626-2455 x 32 (office)
(503) 626-2436 (fax)
http://developer.osdl.org/markw/

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Paul Thomas 2004-03-22 18:09:29 Re: Postmaster not dropping connections on tomcat restart.
Previous Message dinakar 2004-03-22 16:15:02 Re: Postmaster not dropping connections on tomcat restart.