#include <ecpglib.h>
#include <ecpgerrno.h>
#include <sqlca.h>
#include <stdio.h>
Go to the source code of this file.
◆ ECPGdebug
#define ECPGdebug |
( |
|
X, |
|
|
|
Y |
|
) |
| ECPGdebug((X)+100,(Y)) |
◆ PGDLLIMPORT
◆ POSTGRES_SQLCA_H
◆ sqlca
◆ SQLERRMC_LEN
◆ ECPGget_sqlca()
struct sqlca_t* ECPGget_sqlca |
( |
void |
| ) |
|
Definition at line 108 of file misc.c.
static pthread_key_t sqlca_key
void ecpg_init_sqlca(struct sqlca_t *sqlca)
static void ecpg_sqlca_key_init(void)
static pthread_once_t sqlca_key_once
void * pthread_getspecific(pthread_key_t key)
void pthread_setspecific(pthread_key_t key, void *val)
◆ main()
Definition at line 99 of file sql-sqljson_jsontable.c.
104 #line 12 "sqljson_jsontable.pgc"
107 #line 13 "sqljson_jsontable.pgc"
112 {
ECPGconnect(__LINE__, 0,
"ecpg1_regression" , NULL, NULL , NULL, 0);
113 #line 17 "sqljson_jsontable.pgc"
116 #line 17 "sqljson_jsontable.pgc"
119 #line 18 "sqljson_jsontable.pgc"
122 #line 18 "sqljson_jsontable.pgc"
125 {
ECPGdo(__LINE__, 0, 1, NULL, 0,
ECPGst_normal,
"select foo from json_table ( jsonb '[{\"foo\":1}]' , '$[*]' as p0 columns ( foo int ) ) jt ( foo )",
ECPGt_EOIT,
126 ECPGt_int,&(foo),(
long)1,(
long)1,
sizeof(
int),
128 #line 23 "sqljson_jsontable.pgc"
131 #line 23 "sqljson_jsontable.pgc"
133 printf(
"Found foo=%d\n", foo);
135 {
ECPGdo(__LINE__, 0, 1, NULL, 0,
ECPGst_normal,
"select foo from json_table ( jsonb '[{\"foo\":\"1\"}]' , '$[*]' as p0 columns ( nested '$' as p1 columns ( nested path '$' as p11 columns ( foo int ) ) ) ) jt ( foo )",
ECPGt_EOIT,
136 ECPGt_int,&(foo),(
long)1,(
long)1,
sizeof(
int),
138 #line 31 "sqljson_jsontable.pgc"
141 #line 31 "sqljson_jsontable.pgc"
143 printf(
"Found foo=%d\n", foo);
146 #line 34 "sqljson_jsontable.pgc"
149 #line 34 "sqljson_jsontable.pgc"
bool ECPGsetcommit(int lineno, const char *mode, const char *connection_name)
bool ECPGdisconnect(int lineno, const char *connection_name)
bool ECPGconnect(int lineno, int c, const char *name, const char *user, const char *passwd, const char *connection_name, int autocommit)
bool ECPGdo(const int lineno, const int compat, const int force_indicator, const char *connection_name, const bool questionmarks, const int st, const char *query,...)
References ECPGconnect(), ECPGdebug, ECPGdisconnect(), ECPGdo(), ECPGsetcommit(), ECPGst_normal, ECPGt_EOIT, ECPGt_EORT, ECPGt_int, ECPGt_NO_INDICATOR, printf, sqlca, and sqlprint().