107{
108
109
110
111
112
113
114
115
116
117
118
119
120#line 19 "array.pgc"
122
123#line 20 "array.pgc"
125
126#line 21 "array.pgc"
127 short a [ 10 ] = { 9 , 8 , 7 , 6 , 5 , 4 , 3 , 2 , 1 , 0 } ;
128
129#line 22 "array.pgc"
131
132#line 23 "array.pgc"
134
135#line 24 "array.pgc"
137
138#line 25 "array.pgc"
140
141#line 26 "array.pgc"
142 char text [ 25 ] =
"klmnopqrst" ;
143
144#line 27 "array.pgc"
145 char * t = (
char * )
malloc ( 11 ) ;
146
147#line 28 "array.pgc"
148 double f ;
149
150#line 29 "array.pgc"
151
152
153 strcpy(t, "0123456789");
155
157
158 for (
j = 0;
j < 10;
j++) {
162
173 }
174
175 {
ECPGconnect(__LINE__, 0,
"ecpg1_regression" , NULL, NULL , NULL, 0);
176#line 53 "array.pgc"
177
179#line 53 "array.pgc"
180
181
183#line 55 "array.pgc"
184
186#line 55 "array.pgc"
187
188
189 {
ECPGtrans(__LINE__, NULL,
"begin work");
190#line 57 "array.pgc"
191
193#line 57 "array.pgc"
194
195
196 {
ECPGdo(__LINE__, 0, 1, NULL, 0,
ECPGst_normal,
"create table test ( f float , i int , a int [ 10 ] , text char ( 10 ) , ts timestamp [ 10 ] , n numeric [ 10 ] , d date [ 10 ] , inter interval [ 10 ] )",
ECPGt_EOIT,
ECPGt_EORT);
197#line 59 "array.pgc"
198
200#line 59 "array.pgc"
201
202
203 {
ECPGdo(__LINE__, 0, 1, NULL, 0,
ECPGst_normal,
"insert into test ( f , i , a , text , ts , n , d , inter ) values ( 404.90 , 3 , '{0,1,2,3,4,5,6,7,8,9}' , 'abcdefghij' , $1 , $2 , $3 , $4 )",
212#line 61 "array.pgc"
213
215#line 61 "array.pgc"
216
217
218 {
ECPGdo(__LINE__, 0, 1, NULL, 0,
ECPGst_normal,
"insert into test ( f , i , a , text , ts , n , d , inter ) values ( 140787.0 , 2 , $1 , $2 , $3 , $4 , $5 , $6 )",
231#line 63 "array.pgc"
232
234#line 63 "array.pgc"
235
236
237 {
ECPGdo(__LINE__, 0, 1, NULL, 0,
ECPGst_normal,
"insert into test ( f , i , a , text , ts , n , d , inter ) values ( 14.07 , $1 , $2 , $3 , $4 , $5 , $6 , $7 )",
238 ECPGt_int,&(did),(
long)1,(
long)0,
sizeof(
int),
242 ECPGt_char,&(t),(
long)0,(
long)1,(1)*
sizeof(
char),
252#line 65 "array.pgc"
253
255#line 65 "array.pgc"
256
257
259#line 67 "array.pgc"
260
262#line 67 "array.pgc"
263
264
265 for (
j = 0;
j < 10;
j++) {
270 }
271 {
ECPGtrans(__LINE__, NULL,
"begin work");
272#line 75 "array.pgc"
273
275#line 75 "array.pgc"
276
277
283#line 80 "array.pgc"
284
286#line 80 "array.pgc"
287
288
290
291 f=140787;
292 {
ECPGdo(__LINE__, 0, 1, NULL, 0,
ECPGst_normal,
"select a , text , ts , n , d , inter from test where f = $1 ",
297 ECPGt_char,&(t),(
long)0,(
long)1,(1)*
sizeof(
char),
307#line 88 "array.pgc"
308
310#line 88 "array.pgc"
311
312
313 for (
i = 0;
i < 10;
i++)
314 printf(
"Found a[%d] = %d ts[%d] = %s n[%d] = %s d[%d] = %s in[%d] = %s\n",
i,
a[
i],
i,
PGTYPEStimestamp_to_asc(ts[
i]),
i,
PGTYPESnumeric_to_asc(&(n[
i]), -1),
i,
PGTYPESdate_to_asc(d[
i]),
i,
PGTYPESinterval_to_asc(&(in[
i])));
315
316 printf(
"Found text=%10.10s\n", t);
317
323#line 98 "array.pgc"
324
326#line 98 "array.pgc"
327
328
330
332#line 102 "array.pgc"
333
335#line 102 "array.pgc"
336
337
339#line 104 "array.pgc"
340
342#line 104 "array.pgc"
343
344
346#line 106 "array.pgc"
347
349#line 106 "array.pgc"
350
351
353
354 return 0;
355}
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,...)
bool ECPGtrans(int lineno, const char *connection_name, const char *transaction)
char * PGTYPESdate_to_asc(date dDate)
date PGTYPESdate_from_asc(char *str, char **endptr)
interval * PGTYPESinterval_new(void)
interval * PGTYPESinterval_from_asc(char *str, char **endptr)
char * PGTYPESinterval_to_asc(interval *span)
numeric * PGTYPESnumeric_new(void)
char * PGTYPESnumeric_to_asc(numeric *num, int dscale)
int PGTYPESnumeric_from_int(signed int int_val, numeric *var)
timestamp PGTYPEStimestamp_from_asc(char *str, char **endptr)
char * PGTYPEStimestamp_to_asc(timestamp tstamp)