Search Postgresql Archives

emedded SQL in C to get the record type from plpgsql

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



So how can emedded SQL in C to get the record type which returning from plpgsql function?

I have tested as following code:

 

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;

 

 

// imbedded SQL in C

// test4.gpc

 

#include <postgres.h>

#include <funcapi.h>

int db_inner_connect()

{

int DBFlag=-1;

EXEC SQL WHENEVER sqlerror SQLPRINT;

 

        //George modify

        EXEC SQL CONNECT to test USER test IDENTIFIED BY test;

    DBFlag = 0 ; //0

    return DBFlag;

 

SQL_ERROR:

    DBFlag = -1 ; //-1

        return DBFlag;

}

 

int db_inner_disconnect()

{

EXEC SQL DISCONNECT;

return -1;

}

int test(int a)

{

 

EXEC SQL TYPE my_type IS STRUCT

{

int *a;

int *b;

};

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;

 

}

 

 

//main functuin

#include <stdio.h>

#include <stdlib.h>

#include <libpq-fe.h>

#include <pgtypes_numeric.h>

#include <postgres.h>

#include <funcapi.h>

static void exit_nicely(PGconn *conn)

{

    PQfinish(conn);

    exit(1);

}

 

/*************** Main ****************/

/*test4_main.c*/

 

int main(int argc, char **argv)

{

        const char *conninfo;

        PGconn     *conn;

        PGresult   *res;

        int                     nFields;

        int                     i,

                                j;

int  v_test;

int aa=354571;

//int test(int a);

 

 

        if (argc > 1)

              conninfo = argv[1];

        else

                conninfo = "dbname = amri";

 

        v_test=db_inner_connect();

        v_test=test(aa);

        v_test=db_inner_disconnect();

 

return 0;

}

 

 

/*compile pass*/

ecpg -c test4.gpc -I/u1/PostgreSQL/8.4/include

cc -g -o test4 test4_main.c test4.c -I/u1/PostgreSQL/8.4/include/ -I/u1/PostgreSQL/8.4/include/postgresql/server/ -lpgport -lz -lreadline -ltermcap -lcrypt -lxml2 -lresolv -lnsl -ldl -lm -lbsd -lecpg -lpq -L/u1/PostgreSQL/8.4/lib/ -lpgtypes

 

/*running binary file, cause error*/

./test4

SQL error: invalid input syntax for type int: "(100,200)", on line 37

 

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

 

Thanks.

 

Regards,

George

------------------------------------------------------------

Duozhong Sun

Guangdong Revenco Enterprise Co. Ltd. AMRI Department

Tel+86 20 8713 5305,+86 15800005957

Fax+86 20 87135388

Address368 Guangzhou Avenue South,Guangzhou 510300,P.R.C.

------------------------------------------------------------

 


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux