BUG #5298: emedded SQL in C to get the record type from plpgsql

Started by Sun Duozhong(孙多忠)over 16 years ago3 messagesbugs
Jump to latest
#1Sun Duozhong(孙多忠)
sunduozhong@revenco.com

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 ?

#2Craig Ringer
craig@2ndquadrant.com
In reply to: Sun Duozhong(孙多忠) (#1)
Re: BUG #5298: emedded SQL in C to get the record type from plpgsql

George wrote:

The following bug has been logged online:

My project is migrating from Oracle to postgresql,can you help me ?

This is a bug report form.

Perhaps you were looking for the pgsql-general mailing list?

--
Craig Ringer

#3Craig Ringer
craig@2ndquadrant.com
In reply to: Sun Duozhong(孙多忠) (#1)
Re: BUG #5298: emedded SQL in C to get the record type from plpgsql

Sun Duozhong(孙多忠) wrote:

Hi Craig,
Thanks for your reply. Could you help me solve the problem or give me a supporter email address?

http://www.postgresql.org/support/
http://archives.postgresql.org/pgsql-novice/
http://archives.postgresql.org/pgsql-general/
http://www.postgresql.org/support/professional_support

--
Craig Ringer