INSERT question - Mailing list pgsql-novice

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

        CSQLStatement st( sql );
        CSQLStatement st1( sql );
        SQLINTEGER rows;
        long num_codes = 0;

        rows = st.Select( "SELECT * FROM merchant_buyer_country where merchant_id = %lu ",merchant_id );

        if  ( rows )
                return 0;

    char code[4];
        rows = st.Select( "SELECT code FROM country WHERE send IS NOT NULL OR receive IS NOT NULL" );
    SQLBindCol( st.hstmt, 1, SQL_C_CHAR, code, sizeof(code), 0 );
   long i;

   for (i = 0; i < rows; i++ )
   {

          st.Fetch();
          st1.Command("INSERT INTO merchant_buyer_country (merchant_id,country,enabled,group_id)  VALUES(%lu ,'%s', true, %lu )", merchant_id,
 code,group_id);
   }

        st.CloseCursor();
    st1.CloseCursor();

        return 1;
----------------------------------------------------------------------------------------------------------------------------------------

insert into merchant_buyer_country merchant_id,country,enabled,group_id)  values(1203,'US','true',1);