blob: f5cf2112dd00d44c6677ab7d5b8e2056fe29c4fb (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
|
/*
* pgmultiresult.c
*
*/
#include <stdio.h>
#include "libpq-fe.h"
#include "../halt.h"
#include "libpgeasy.h"
int
main(int argc, char **argv)
{
char query[4000];
char val[4000];
char optstr[256];
PGresult *res1, *res2;
int res1_done = 0, res2_done = 0;
if (argc != 2)
halt("Usage: %s database\n", argv[0]);
snprintf(optstr, 256, "dbname=%s", argv[1]);
connectdb(optstr);
doquery("\
SELECT lanname \
FROM pg_language \
ORDER BY lanname \
");
res1 = get_result();
doquery("\
SELECT amname \
FROM pg_am \
ORDER BY amname \
");
res2 = get_result();
while (!res1_done && !res2_done)
{
set_result(res1);
if (!res1_done)
{
if (fetch(val) != END_OF_TUPLES)
puts(val);
else res1_done = 1;
}
res1 = get_result();
set_result(res2);
if (!res2_done)
{
if (fetch(val) != END_OF_TUPLES)
puts(val);
else res2_done = 1;
}
res2 = get_result();
}
disconnectdb();
return 0;
}
|
