BUG #5298: emedded SQL in C to get the record type from plpgsql
| От | George |
|---|---|
| Тема | BUG #5298: emedded SQL in C to get the record type from plpgsql |
| Дата | |
| Msg-id | 201001280413.o0S4DFJX029357@wwwmaster.postgresql.org обсуждение исходный текст |
| Ответы |
Re: BUG #5298: emedded SQL in C to get the record type from
plpgsql
|
| Список | pgsql-bugs |
The following bug has been logged online:
Bug reference: 5298
Logged by: George
Email address: sunduozhong@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 ?
В списке pgsql-bugs по дате отправления: