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/
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. |