Debian Codegraph @

src/interfaces/ecpg/test/sql/sqljson_jsontable.pgc

raw
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 main ()
10 {
11 EXEC SQL BEGIN DECLARE SECTION;
12 int foo;
13 EXEC SQL END DECLARE SECTION;
14
15 ECPGdebug (1, stderr);
16
17 EXEC SQL CONNECT TO REGRESSDB1;
18 EXEC SQL SET AUTOCOMMIT = ON;
19
20 EXEC SQL SELECT foo INTO :foo FROM JSON_TABLE(jsonb '[{"foo":1}]', '$[*]' AS p0
21 COLUMNS (
22 foo int
23 )) jt (foo);
24 printf("Found foo=%d\n", foo);
25
26 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 printf("Found foo=%d\n", foo);
33
34 EXEC SQL DISCONNECT;
35
36 return 0;
37 }