bonjour,

j'essaie en c de recuperer les types des colonnes d'une requete.
pour cela j'utilise cette fonction
Code : Sélectionner tout - Visualiser dans une fenêtre à part
 PQftype(Y_Result,Y_col);
le truc, c'est que j'aimerais comparer ce type et faire des choses differentes suivant le type.

apres recherche, ce que renvoi cette méthode est defini dans le fichier pg_types.h

j'ai donc rajouter ce fichier en include
[CODE]
#include "server/catalog/pg_type.h"
[CODE]

mais lors de la compilation (avec cl.exe) j'ai tout un tas d'erreur que voici
Code : Sélectionner tout - Visualiser dans une fenêtre à part
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
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
 
C:\Program Files\PostgreSQL\8.3\include\server\nodes/nodes.h(390) : error C2054: expected '(' to follow 'PGDLLIMPORT'
C:\Program Files\PostgreSQL\8.3\include\server\nodes/nodes.h(390) : error C2085: 'newNodeMacroHolder' : not in formal parameter list
C:\Program Files\PostgreSQL\8.3\include\server\nodes/nodes.h(414) : error C2085: 'nodeToString' : not in formal parameter list
C:\Program Files\PostgreSQL\8.3\include\server\nodes/nodes.h(419) : error C2085: 'stringToNode' : not in formal parameter list
C:\Program Files\PostgreSQL\8.3\include\server\nodes/nodes.h(424) : error C2085: 'copyObject' : not in formal parameter list
C:\Program Files\PostgreSQL\8.3\include\server\nodes/nodes.h(429) : error C2085: 'bool' : not in formal parameter list
C:\Program Files\PostgreSQL\8.3\include\server\nodes/nodes.h(429) : error C2146: syntax error : missing ',' before identifier 'equal'
C:\Program Files\PostgreSQL\8.3\include\server\nodes/nodes.h(429) : error C2143: syntax error : missing ';' before '('
C:\Program Files\PostgreSQL\8.3\include\server\nodes/nodes.h(429) : error C2059: syntax error : ')'
C:\Program Files\PostgreSQL\8.3\include\server/catalog/pg_type.h(43) : error C2059: syntax error : ','
C:\Program Files\PostgreSQL\8.3\include\server/catalog/pg_type.h(43) : error C2143: syntax error : missing ')' before 'constant'
C:\Program Files\PostgreSQL\8.3\include\server/catalog/pg_type.h(43) : error C2143: syntax error : missing '{' before 'constant'
C:\Program Files\PostgreSQL\8.3\include\server/catalog/pg_type.h(43) : error C2059: syntax error : '<Unknown>'
C:\Program Files\PostgreSQL\8.3\include\server/catalog/pg_type.h(43) : error C2059: syntax error : ')'
C:\Program Files\PostgreSQL\8.3\include\server/catalog/pg_type.h(217) : error C2143: syntax error : missing '{' before '*'
C:\Program Files\PostgreSQL\8.3\include\server/catalog/pg_type.h(265) : error C2146: syntax error : missing ')' before identifier 'OID'
C:\Program Files\PostgreSQL\8.3\include\server/catalog/pg_type.h(265) : error C2061: syntax error : identifier 'OID'
C:\Program Files\PostgreSQL\8.3\include\server/catalog/pg_type.h(265) : error C2059: syntax error : ';'
C:\Program Files\PostgreSQL\8.3\include\server/catalog/pg_type.h(265) : error C2513: '/*global*/ ' : no variable declared before '='
C:\Program Files\PostgreSQL\8.3\include\server/catalog/pg_type.h(265) : error C2064: term does not evaluate to a function taking -22 arguments
C:\Program Files\PostgreSQL\8.3\include\server/catalog/pg_type.h(265) : error C2065: 'bool' : undeclared identifier
C:\Program Files\PostgreSQL\8.3\include\server/catalog/pg_type.h(265) : error C2146: syntax error : missing ')' before identifier 'PGNSP'
C:\Program Files\PostgreSQL\8.3\include\server/catalog/pg_type.h(265) : error C2017: illegal escape sequence
C:\Program Files\PostgreSQL\8.3\include\server/catalog/pg_type.h(265) : error C2059: syntax error : ')'
C:\Program Files\PostgreSQL\8.3\include\server/catalog/pg_type.h(265) : error C2059: syntax error : ')'
C:\Program Files\PostgreSQL\8.3\include\server/catalog/pg_type.h(266) : error C2143: syntax error : missing ')' before 'string'
C:\Program Files\PostgreSQL\8.3\include\server/catalog/pg_type.h(266) : error C2143: syntax error : missing '{' before 'string'
C:\Program Files\PostgreSQL\8.3\include\server/catalog/pg_type.h(266) : error C2059: syntax error : '<Unknown>'
C:\Program Files\PostgreSQL\8.3\include\server/catalog/pg_type.h(266) : error C2059: syntax error : ')'
C:\Program Files\PostgreSQL\8.3\include\server/catalog/pg_type.h(269) : error C2146: syntax error : missing ')' before identifier 'OID'
C:\Program Files\PostgreSQL\8.3\include\server/catalog/pg_type.h(269) : error C2061: syntax error : identifier 'OID'
C:\Program Files\PostgreSQL\8.3\include\server/catalog/pg_type.h(269) : error C2059: syntax error : ';'
C:\Program Files\PostgreSQL\8.3\include\server/catalog/pg_type.h(269) : error C2513: '/*global*/ ' : no variable declared before '='
C:\Program Files\PostgreSQL\8.3\include\server/catalog/pg_type.h(269) : error C2064: term does not evaluate to a function taking -22 arguments
C:\Program Files\PostgreSQL\8.3\include\server/catalog/pg_type.h(269) : error C2065: 'bytea' : undeclared identifier
C:\Program Files\PostgreSQL\8.3\include\server/catalog/pg_type.h(269) : error C2146: syntax error : missing ')' before identifier 'PGNSP'
C:\Program Files\PostgreSQL\8.3\include\server/catalog/pg_type.h(269) : error C2017: illegal escape sequence
C:\Program Files\PostgreSQL\8.3\include\server/catalog/pg_type.h(269) : error C2059: syntax error : ')'
C:\Program Files\PostgreSQL\8.3\include\server/catalog/pg_type.h(269) : error C2059: syntax error : ')'
C:\Program Files\PostgreSQL\8.3\include\server/catalog/pg_type.h(270) : error C2143: syntax error : missing ')' before 'string'
C:\Program Files\PostgreSQL\8.3\include\server/catalog/pg_type.h(270) : error C2143: syntax error : missing '{' before 'string'
C:\Program Files\PostgreSQL\8.3\include\server/catalog/pg_type.h(270) : error C2059: syntax error : '<Unknown>'
C:\Program Files\PostgreSQL\8.3\include\server/catalog/pg_type.h(270) : error C2059: syntax error : ')'
C:\Program Files\PostgreSQL\8.3\include\server/catalog/pg_type.h(273) : error C2146: syntax error : missing ')' before identifier 'OID'
C:\Program Files\PostgreSQL\8.3\include\server/catalog/pg_type.h(273) : error C2061: syntax error : identifier 'OID'
C:\Program Files\PostgreSQL\8.3\include\server/catalog/pg_type.h(273) : error C2059: syntax error : ';'
C:\Program Files\PostgreSQL\8.3\include\server/catalog/pg_type.h(273) : error C2513: '/*global*/ ' : no variable declared before '='
C:\Program Files\PostgreSQL\8.3\include\server/catalog/pg_type.h(273) : error C2064: term does not evaluate to a function taking -22 arguments
C:\Program Files\PostgreSQL\8.3\include\server/catalog/pg_type.h(273) : error C2143: syntax error : missing ')' before 'type'
C:\Program Files\PostgreSQL\8.3\include\server/catalog/pg_type.h(273) : error C2017: illegal escape sequence
C:\Program Files\PostgreSQL\8.3\include\server/catalog/pg_type.h(273) : error C2059: syntax error : ')'
C:\Program Files\PostgreSQL\8.3\include\server/catalog/pg_type.h(273) : error C2059: syntax error : ')'
C:\Program Files\PostgreSQL\8.3\include\server/catalog/pg_type.h(274) : error C2143: syntax error : missing ')' before 'string'
C:\Program Files\PostgreSQL\8.3\include\server/catalog/pg_type.h(274) : error C2143: syntax error : missing '{' before 'string'
C:\Program Files\PostgreSQL\8.3\include\server/catalog/pg_type.h(274) : error C2059: syntax error : '<Unknown>'
C:\Program Files\PostgreSQL\8.3\include\server/catalog/pg_type.h(274) : error C2059: syntax error : ')'
C:\Program Files\PostgreSQL\8.3\include\server/catalog/pg_type.h(277) : error C2146: syntax error : missing ')' before identifier 'OID'
C:\Program Files\PostgreSQL\8.3\include\server/catalog/pg_type.h(277) : error C2061: syntax error : identifier 'OID'
C:\Program Files\PostgreSQL\8.3\include\server/catalog/pg_type.h(277) : error C2059: syntax error : ';'
C:\Program Files\PostgreSQL\8.3\include\server/catalog/pg_type.h(277) : error C2513: '/*global*/ ' : no variable declared before '='
C:\Program Files\PostgreSQL\8.3\include\server/catalog/pg_type.h(277) : error C2064: term does not evaluate to a function taking -22 arguments
C:\Program Files\PostgreSQL\8.3\include\server/catalog/pg_type.h(277) : error C2065: 'name' : undeclared identifier
C:\Program Files\PostgreSQL\8.3\include\server/catalog/pg_type.h(277) : error C2146: syntax error : missing ')' before identifier 'PGNSP'
C:\Program Files\PostgreSQL\8.3\include\server/catalog/pg_type.h(277) : error C2017: illegal escape sequence
C:\Program Files\PostgreSQL\8.3\include\server/catalog/pg_type.h(277) : error C2059: syntax error : ')'
C:\Program Files\PostgreSQL\8.3\include\server/catalog/pg_type.h(277) : error C2059: syntax error : ')'
C:\Program Files\PostgreSQL\8.3\include\server/catalog/pg_type.h(278) : error C2143: syntax error : missing ')' before 'string'
C:\Program Files\PostgreSQL\8.3\include\server/catalog/pg_type.h(278) : error C2143: syntax error : missing '{' before 'string'
C:\Program Files\PostgreSQL\8.3\include\server/catalog/pg_type.h(278) : error C2059: syntax error : '<Unknown>'
C:\Program Files\PostgreSQL\8.3\include\server/catalog/pg_type.h(278) : error C2059: syntax error : ')'
C:\Program Files\PostgreSQL\8.3\include\server/catalog/pg_type.h(281) : error C2146: syntax error : missing ')' before identifier 'OID'
C:\Program Files\PostgreSQL\8.3\include\server/catalog/pg_type.h(281) : error C2061: syntax error : identifier 'OID'
C:\Program Files\PostgreSQL\8.3\include\server/catalog/pg_type.h(281) : error C2059: syntax error : ';'
C:\Program Files\PostgreSQL\8.3\include\server/catalog/pg_type.h(281) : error C2513: '/*global*/ ' : no variable declared before '='
C:\Program Files\PostgreSQL\8.3\include\server/catalog/pg_type.h(281) : error C2064: term does not evaluate to a function taking -22 arguments
C:\Program Files\PostgreSQL\8.3\include\server/catalog/pg_type.h(281) : error C2065: 'int8' : undeclared identifier
C:\Program Files\PostgreSQL\8.3\include\server/catalog/pg_type.h(281) : error C2146: syntax error : missing ')' before identifier 'PGNSP'
C:\Program Files\PostgreSQL\8.3\include\server/catalog/pg_type.h(281) : error C2017: illegal escape sequence
C:\Program Files\PostgreSQL\8.3\include\server/catalog/pg_type.h(281) : error C2059: syntax error : ')'
C:\Program Files\PostgreSQL\8.3\include\server/catalog/pg_type.h(281) : error C2059: syntax error : ')'
C:\Program Files\PostgreSQL\8.3\include\server/catalog/pg_type.h(282) : error C2143: syntax error : missing ')' before 'string'
C:\Program Files\PostgreSQL\8.3\include\server/catalog/pg_type.h(282) : error C2143: syntax error : missing '{' before 'string'
C:\Program Files\PostgreSQL\8.3\include\server/catalog/pg_type.h(282) : error C2059: syntax error : '<Unknown>'
C:\Program Files\PostgreSQL\8.3\include\server/catalog/pg_type.h(282) : error C2059: syntax error : ')'
C:\Program Files\PostgreSQL\8.3\include\server/catalog/pg_type.h(285) : error C2146: syntax error : missing ')' before identifier 'OID'
C:\Program Files\PostgreSQL\8.3\include\server/catalog/pg_type.h(285) : error C2061: syntax error : identifier 'OID'
C:\Program Files\PostgreSQL\8.3\include\server/catalog/pg_type.h(285) : error C2059: syntax error : ';'
C:\Program Files\PostgreSQL\8.3\include\server/catalog/pg_type.h(285) : error C2513: '/*global*/ ' : no variable declared before '='
C:\Program Files\PostgreSQL\8.3\include\server/catalog/pg_type.h(285) : error C2064: term does not evaluate to a function taking -22 arguments
C:\Program Files\PostgreSQL\8.3\include\server/catalog/pg_type.h(285) : error C2065: 'int2' : undeclared identifier
C:\Program Files\PostgreSQL\8.3\include\server/catalog/pg_type.h(285) : error C2146: syntax error : missing ')' before identifier 'PGNSP'
C:\Program Files\PostgreSQL\8.3\include\server/catalog/pg_type.h(285) : error C2017: illegal escape sequence
C:\Program Files\PostgreSQL\8.3\include\server/catalog/pg_type.h(285) : error C2059: syntax error : ')'
C:\Program Files\PostgreSQL\8.3\include\server/catalog/pg_type.h(285) : error C2059: syntax error : ')'
C:\Program Files\PostgreSQL\8.3\include\server/catalog/pg_type.h(286) : error C2143: syntax error : missing ')' before 'string'
C:\Program Files\PostgreSQL\8.3\include\server/catalog/pg_type.h(286) : error C2143: syntax error : missing '{' before 'string'
C:\Program Files\PostgreSQL\8.3\include\server/catalog/pg_type.h(286) : error C2059: syntax error : '<Unknown>'
C:\Program Files\PostgreSQL\8.3\include\server/catalog/pg_type.h(286) : error C2059: syntax error : ')'
C:\Program Files\PostgreSQL\8.3\include\server/catalog/pg_type.h(289) : error C2146: syntax error : missing ')' before identifier 'OID'
C:\Program Files\PostgreSQL\8.3\include\server/catalog/pg_type.h(289) : error C2061: syntax error : identifier 'OID'
C:\Program Files\PostgreSQL\8.3\include\server/catalog/pg_type.h(289) : error C2059: syntax error : ';'
C:\Program Files\PostgreSQL\8.3\include\server/catalog/pg_type.h(289) : fatal error C1003: error count exceeds 100; stopping compilation

qqn aurait il une idée parce que RE-hardcodé les constantes, ....

merci


a++