Advertisement
Guest User

Store Procedure

a guest
Jan 29th, 2015
425
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
C 0.90 KB | None | 0 0
  1. Datum wtt_add_account(PG_FUNCTION_ARGS)
  2. {
  3.   ArrayType *balance_info
  4.   Oid array_type;
  5.   int16 array_element_type_width;
  6.   bool array_element_type_by_value;
  7.   char array_element_type_alignment_code;
  8.   Datum *array_content;
  9.   bool *array_null_flags;
  10.   HeapTupleHeader t;
  11.   int arr_len;
  12.   char *tmp;
  13.  
  14.  
  15.   balance_info = PG_GETARG_ARRAYTYPE_P(0);
  16.   array_type = ARR_ELEMTYPE(balance_info);
  17.  get_typlenbyvalalign(array_type,&array_element_type_width,&array_element_type_by_value,&array_element_type_alignment_code);
  18.  
  19.   deconstruct_array(balance_info,array_type,array_element_type_width,array_element_type_by_value,
  20. array_element_type_alignm  ent_code,&array_content,&array_null_flags,&arr_len);
  21.  
  22.   t = DatumGetHeapTupleHeader(array_content[0]);
  23.  
  24.   tmp = (char*)GetAttributeByNum(t,1,&isNull);
  25.  
  26.   ereport( INFO, ( errcode( ERRCODE_SUCCESSFUL_COMPLETION ), errmsg( "balance_info: %s\n",tmp)));
  27. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement