Line data    Source code

       1              : #include <stdio.h>
       2              : 
       3              : EXEC SQL INCLUDE sqlca;
       4              : exec sql include ../regression;
       5              : 
       6              : EXEC SQL WHENEVER SQLERROR sqlprint;
       7              : 
       8              : int
       9            0 : main ()
      10              : {
      11              : EXEC SQL BEGIN DECLARE SECTION;
      12            0 :   int foo;
      13              : EXEC SQL END DECLARE SECTION;
      14              : 
      15            0 :   ECPGdebug (1, stderr);
      16              : 
      17            0 :   EXEC SQL CONNECT TO REGRESSDB1;
      18            0 :   EXEC SQL SET AUTOCOMMIT = ON;
      19            0 : 
      20            0 :   EXEC SQL SELECT foo INTO :foo FROM JSON_TABLE(jsonb '[{"foo":1}]', '$[*]' AS p0
      21              :         COLUMNS (
      22              :                         foo int
      23              :         )) jt (foo);
      24            0 :   printf("Found foo=%d\n", foo);
      25              : 
      26            0 :   EXEC SQL SELECT foo INTO :foo FROM JSON_TABLE(jsonb '[{"foo":"1"}]', '$[*]' AS p0
      27              :         COLUMNS (
      28              :                 NESTED '$' AS p1 COLUMNS (
      29              :                         NESTED PATH '$' AS p11 COLUMNS ( foo int )
      30              :                 )
      31              :         )) jt (foo);
      32            0 :   printf("Found foo=%d\n", foo);
      33              : 
      34            0 :   EXEC SQL DISCONNECT;
      35            0 : 
      36            0 :   return 0;
      37            0 : }