The following bug has been logged online: Bug reference: 5298 Logged by: George Email address: sunduozh...@revenco.com PostgreSQL version: 8.4.2 Operating system: Red Hat Linux AS 4 Description: emedded SQL in C to get the record type from plpgsql Details:
CREATE OR REPLACE FUNCTION test4(IN a integer, OUT b int,OUT c int) AS $BODY$ declare begin b:=100; c:=200; return; END $BODY$ LANGUAGE 'plpgsql' VOLATILE COST 100; int test(int a) { EXEC SQL TYPE my_type IS STRUCT { int b[1]; int c[1]; }; EXEC SQL BEGIN DECLARE SECTION; my_type ppp; EXEC SQL END DECLARE SECTION; EXEC SQL WHENEVER sqlerror SQLPRINT; EXEC SQL select test4(1) into :ppp; EXEC SQL COMMIT; return 0; } So how can emedded SQL in C to get the record type which returning from plpgsql function? My project is migrating from Oracle to postgresql,can you help me ? -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs