/pgtypes.h

 1/* File:			pgtypes.h
 2 *
 3 * Description:		See "pgtypes.c"
 4 *
 5 * Comments:		See "notice.txt" for copyright and license information.
 6 *
 7 */
 8
 9#ifndef __PGTYPES_H__
10#define __PGTYPES_H__
11
12/* the type numbers are defined by the OID's of the types' rows */
13/* in table pg_type */
14
15
16#ifdef NOT_USED
17#define PG_TYPE_LO				????	/* waiting for permanent type */
18#endif
19
20#define	MS_ACCESS_SERIAL		"int identity"
21#define PG_TYPE_BOOL			16
22#define PG_TYPE_BYTEA			17
23#define PG_TYPE_CHAR			18
24#define PG_TYPE_NAME			19
25#define PG_TYPE_INT8			20
26#define PG_TYPE_INT2			21
27#define PG_TYPE_INT2VECTOR		22
28#define PG_TYPE_INT4			23
29#define PG_TYPE_REGPROC			24
30#define PG_TYPE_TEXT			25
31#define PG_TYPE_OID				26
32#define PG_TYPE_TID				27
33#define PG_TYPE_XID				28
34#define PG_TYPE_CID				29
35#define PG_TYPE_OIDVECTOR		30
36#define PG_TYPE_SET				32
37#define PG_TYPE_XML			142
38#define PG_TYPE_XMLARRAY		143
39#define PG_TYPE_CHAR2			409
40#define PG_TYPE_CHAR4			410
41#define PG_TYPE_CHAR8			411
42#define PG_TYPE_POINT			600
43#define PG_TYPE_LSEG			601
44#define PG_TYPE_PATH			602
45#define PG_TYPE_BOX				603
46#define PG_TYPE_POLYGON			604
47#define PG_TYPE_FILENAME		605
48#define PG_TYPE_CIDR			650
49#define PG_TYPE_FLOAT4			700
50#define PG_TYPE_FLOAT8			701
51#define PG_TYPE_ABSTIME			702
52#define PG_TYPE_RELTIME			703
53#define PG_TYPE_TINTERVAL		704
54#define PG_TYPE_UNKNOWN			705
55#define PG_TYPE_MONEY			790
56#define PG_TYPE_OIDINT2			810
57#define PG_TYPE_MACADDR			829
58#define PG_TYPE_INET			869
59#define PG_TYPE_OIDINT4			910
60#define PG_TYPE_OIDNAME			911
61#define PG_TYPE_TEXTARRAY		1009
62#define PG_TYPE_BPCHARARRAY		1014
63#define PG_TYPE_VARCHARARRAY		1015
64#define PG_TYPE_BPCHAR			1042
65#define PG_TYPE_VARCHAR			1043
66#define PG_TYPE_DATE			1082
67#define PG_TYPE_TIME			1083
68#define PG_TYPE_TIMESTAMP_NO_TMZONE	1114		/* since 7.2 */
69#define PG_TYPE_DATETIME		1184
70#define PG_TYPE_TIME_WITH_TMZONE	1266		/* since 7.1 */
71#define PG_TYPE_TIMESTAMP		1296	/* deprecated since 7.0 */
72#define PG_TYPE_NUMERIC			1700
73#define PG_TYPE_RECORD			2249
74#define PG_TYPE_VOID			2278
75#define INTERNAL_ASIS_TYPE		(-9999)
76
77#endif