142 lines
6.7 KiB
C
142 lines
6.7 KiB
C
/* File: pgtypes.h
|
|
*
|
|
* Description: See "pgtypes.c"
|
|
*
|
|
* Comments: See "readme.txt" for copyright and license information.
|
|
*
|
|
*/
|
|
|
|
#ifndef __PGTYPES_H__
|
|
#define __PGTYPES_H__
|
|
|
|
#include "psqlodbc.h"
|
|
|
|
/* the type numbers are defined by the OID's of the types' rows */
|
|
/* in table pg_type */
|
|
|
|
|
|
#ifdef NOT_USED
|
|
#define PG_TYPE_LO ???? /* waiting for permanent type */
|
|
#endif
|
|
|
|
#define MS_ACCESS_SERIAL "int identity"
|
|
#define PG_TYPE_BOOL 16
|
|
#define PG_TYPE_BYTEA 17
|
|
#define PG_TYPE_CHAR 18
|
|
#define PG_TYPE_NAME 19
|
|
#define PG_TYPE_INT8 20
|
|
#define PG_TYPE_INT2 21
|
|
#define PG_TYPE_INT2VECTOR 22
|
|
#define PG_TYPE_INT4 23
|
|
#define PG_TYPE_REGPROC 24
|
|
#define PG_TYPE_TEXT 25
|
|
#define PG_TYPE_OID 26
|
|
#define PG_TYPE_TID 27
|
|
#define PG_TYPE_XID 28
|
|
#define PG_TYPE_CID 29
|
|
#define PG_TYPE_OIDVECTOR 30
|
|
#define PG_TYPE_XML 142
|
|
#define PG_TYPE_XMLARRAY 143
|
|
#define PG_TYPE_CIDR 650
|
|
#define PG_TYPE_FLOAT4 700
|
|
#define PG_TYPE_FLOAT8 701
|
|
#define PG_TYPE_ABSTIME 702
|
|
#define PG_TYPE_UNKNOWN 705
|
|
#define PG_TYPE_MONEY 790
|
|
#define PG_TYPE_MACADDR 829
|
|
#define PG_TYPE_INET 869
|
|
#define PG_TYPE_TEXTARRAY 1009
|
|
#define PG_TYPE_BPCHARARRAY 1014
|
|
#define PG_TYPE_VARCHARARRAY 1015
|
|
#define PG_TYPE_BPCHAR 1042
|
|
#define PG_TYPE_VARCHAR 1043
|
|
#define PG_TYPE_DATE 1082
|
|
#define PG_TYPE_TIME 1083
|
|
#define PG_TYPE_TIMESTAMP_NO_TMZONE 1114 /* since 7.2 */
|
|
#define PG_TYPE_DATETIME 1184 /* timestamptz */
|
|
#define PG_TYPE_INTERVAL 1186
|
|
#define PG_TYPE_TIME_WITH_TMZONE 1266 /* since 7.1 */
|
|
#define PG_TYPE_TIMESTAMP 1296 /* deprecated since 7.0 */
|
|
#define PG_TYPE_BIT 1560
|
|
#define PG_TYPE_NUMERIC 1700
|
|
#define PG_TYPE_REFCURSOR 1790
|
|
#define PG_TYPE_RECORD 2249
|
|
#define PG_TYPE_VOID 2278
|
|
#define PG_TYPE_UUID 2950
|
|
#define PG_TYPE_NVARCHAR2 3969
|
|
#define PG_TYPE_INT1 5545
|
|
#define PG_TYPE_SMALLDATETIME 9003
|
|
#define INTERNAL_ASIS_TYPE (-9999)
|
|
|
|
#define TYPE_MAY_BE_ARRAY(type) ((type) == PG_TYPE_XMLARRAY || ((type) >= 1000 && (type) <= 1041))
|
|
/* extern Int4 pgtypes_defined[]; */
|
|
extern SQLSMALLINT sqlTypes[];
|
|
|
|
/* Defines for pgtype_precision */
|
|
#define PG_ATP_UNSET (-3) /* atttypmod */
|
|
#define PG_ADT_UNSET (-3) /* adtsize_or_longestlen */
|
|
#define PG_UNKNOWNS_UNSET 0 /* UNKNOWNS_AS_MAX */
|
|
#define PG_WIDTH_OF_BOOLS_AS_CHAR 5
|
|
|
|
/*
|
|
* SQL_INTERVAL support is disabled because I found
|
|
* some applications which are unhappy with it.
|
|
*
|
|
#define PG_INTERVAL_AS_SQL_INTERVAL
|
|
*/
|
|
|
|
OID pg_true_type(const ConnectionClass *, OID, OID);
|
|
OID sqltype_to_pgtype(const ConnectionClass *conn, SQLSMALLINT fSqlType);
|
|
OID sqltype_to_bind_pgtype(const ConnectionClass *conn, SQLSMALLINT fSqlType);
|
|
const char *sqltype_to_pgcast(const ConnectionClass *conn, SQLSMALLINT fSqlType);
|
|
|
|
SQLSMALLINT pgtype_to_concise_type(const StatementClass *stmt, OID type, int col, int handle_unknown_size_as);
|
|
SQLSMALLINT pgtype_to_sqldesctype(const StatementClass *stmt, OID type, int col, int handle_unknown_size_as);
|
|
SQLSMALLINT pgtype_to_datetime_sub(const StatementClass *stmt, OID type, int col);
|
|
const char *pgtype_to_name(const StatementClass *stmt, OID type, int col, BOOL auto_increment);
|
|
|
|
SQLSMALLINT pgtype_attr_to_concise_type(const ConnectionClass *conn, OID type, int typmod, int adtsize_or_longestlen,int handle_unknown_size_as);
|
|
SQLSMALLINT pgtype_attr_to_sqldesctype(const ConnectionClass *conn, OID type, int typmod, int adtsize_or_longestlen, int handle_unknown_size_as);
|
|
SQLSMALLINT pgtype_attr_to_datetime_sub(const ConnectionClass *conn, OID type, int typmod);
|
|
SQLSMALLINT pgtype_attr_to_ctype(const ConnectionClass *conn, OID type, int typmod);
|
|
const char *pgtype_attr_to_name(const ConnectionClass *conn, OID type, int typmod, BOOL auto_increment);
|
|
Int4 pgtype_attr_column_size(const ConnectionClass *conn, OID type, int atttypmod, int adtsize_or_longest, int handle_unknown_size_as);
|
|
Int4 pgtype_attr_buffer_length(const ConnectionClass *conn, OID type, int atttypmod, int adtsize_or_longestlen, int handle_unknown_size_as);
|
|
Int4 pgtype_attr_display_size(const ConnectionClass *conn, OID type, int atttypmod, int adtsize_or_longestlen, int handle_unknown_size_as);
|
|
Int2 pgtype_attr_decimal_digits(const ConnectionClass *conn, OID type, int atttypmod, int adtsize_or_longestlen, int handle_unknown_size_as);
|
|
Int4 pgtype_attr_transfer_octet_length(const ConnectionClass *conn, OID type, int atttypmod, int handle_unknown_size_as);
|
|
SQLSMALLINT pgtype_attr_precision(const ConnectionClass *conn, OID type, int atttypmod, int adtsize_or_longest, int handle_unknown_size_as);
|
|
Int4 pgtype_attr_desclength(const ConnectionClass *conn, OID type, int atttypmod, int adtsize_or_longestlen, int handle_unknown_size_as);
|
|
Int2 pgtype_attr_scale(const ConnectionClass *conn, OID type, int atttypmod, int adtsize_or_longestlen, int handle_unknown_size_as);
|
|
|
|
/* These functions can use static numbers or result sets(col parameter) */
|
|
Int4 pgtype_column_size(const StatementClass *stmt, OID type, int col, int handle_unknown_size_as); /* corresponds to "precision" in ODBC 2.x */
|
|
SQLSMALLINT pgtype_precision(const StatementClass *stmt, OID type, int col, int handle_unknown_size_as); /* "precsion in ODBC 3.x */
|
|
/* the following size/length are of Int4 due to PG restriction */
|
|
Int4 pgtype_display_size(const StatementClass *stmt, OID type, int col, int handle_unknown_size_as);
|
|
Int4 pgtype_buffer_length(const StatementClass *stmt, OID type, int col, int handle_unknown_size_as);
|
|
Int4 pgtype_desclength(const StatementClass *stmt, OID type, int col, int handle_unknown_size_as);
|
|
|
|
SQLSMALLINT pgtype_decimal_digits(const StatementClass *stmt, OID type, int col); /* corresponds to "scale" in ODBC 2.x */
|
|
SQLSMALLINT pgtype_min_decimal_digits(const ConnectionClass *conn, OID type); /* corresponds to "min_scale" in ODBC 2.x */
|
|
SQLSMALLINT pgtype_max_decimal_digits(const ConnectionClass *conn, OID type); /* corresponds to "max_scale" in ODBC 2.x */
|
|
SQLSMALLINT pgtype_scale(const StatementClass *stmt, OID type, int col); /* ODBC 3.x " */
|
|
Int2 pgtype_radix(const ConnectionClass *conn, OID type);
|
|
Int2 pgtype_nullable(const ConnectionClass *conn, OID type);
|
|
Int2 pgtype_auto_increment(const ConnectionClass *conn, OID type);
|
|
Int2 pgtype_case_sensitive(const ConnectionClass *conn, OID type);
|
|
Int2 pgtype_money(const ConnectionClass *conn, OID type);
|
|
Int2 pgtype_searchable(const ConnectionClass *conn, OID type);
|
|
Int2 pgtype_unsigned(const ConnectionClass *conn, OID type);
|
|
const char *pgtype_literal_prefix(const ConnectionClass *conn, OID type);
|
|
const char *pgtype_literal_suffix(const ConnectionClass *conn, OID type);
|
|
const char *pgtype_create_params(const ConnectionClass *conn, OID type);
|
|
|
|
SQLSMALLINT sqltype_to_default_ctype(const ConnectionClass *stmt, SQLSMALLINT sqltype);
|
|
Int4 ctype_length(SQLSMALLINT ctype);
|
|
|
|
SQLSMALLINT ansi_to_wtype(const ConnectionClass *self, SQLSMALLINT ansitype);
|
|
|
|
#define USE_ZONE FALSE
|
|
#endif
|