Committed by Greg Sabino Mullane <[email protected]>
Make arrayout field a hair larger to account for growing
size in PG source. Merely pretties up types.c
---
types.c | 304 ++++++++++++++++++++++++++++++++--------------------------------
1 file changed, 152 insertions(+), 152 deletions(-)
diff --git a/types.c b/types.c
index 3c717b2..4234077 100644
--- a/types.c
+++ b/types.c
@@ -15,158 +15,158 @@
#include "Pg.h"
static sql_type_info_t pg_types[] = {
- {PG_ABSTIMEARRAY ,"_abstime" ,1,',',"array_out"
,quote_string,dequote_string,{0},0},
- {PG_ACLITEMARRAY ,"_aclitem" ,1,',',"array_out"
,quote_string,dequote_string,{0},0},
- {PG_BITARRAY ,"_bit" ,1,',',"array_out"
,quote_string,dequote_string,{0},0},
- {PG_BOOLARRAY ,"_bool" ,1,',',"array_out"
,quote_string,dequote_string,{0},3},
- {PG_BOXARRAY ,"_box" ,1,';',"array_out"
,quote_string,dequote_string,{0},0},
- {PG_BPCHARARRAY ,"_bpchar" ,1,',',"array_out"
,quote_string,dequote_string,{0},0},
- {PG_BYTEAARRAY ,"_bytea" ,1,',',"array_out"
,quote_string,dequote_string,{0},0},
- {PG_CHARARRAY ,"_char" ,1,',',"array_out"
,quote_string,dequote_string,{0},0},
- {PG_CIDARRAY ,"_cid" ,1,',',"array_out"
,quote_string,dequote_string,{0},0},
- {PG_CIDRARRAY ,"_cidr" ,1,',',"array_out"
,quote_string,dequote_string,{0},0},
- {PG_CIRCLEARRAY ,"_circle" ,1,',',"array_out"
,quote_string,dequote_string,{0},0},
- {PG_CSTRINGARRAY ,"_cstring" ,1,',',"array_out"
,quote_string,dequote_string,{0},0},
- {PG_DATEARRAY ,"_date" ,1,',',"array_out"
,quote_string,dequote_string,{0},0},
- {PG_DATERANGEARRAY ,"_daterange" ,1,',',"array_out"
,quote_string,dequote_string,{0},0},
- {PG_FLOAT4ARRAY ,"_float4" ,1,',',"array_out"
,quote_string,dequote_string,{0},2},
- {PG_FLOAT8ARRAY ,"_float8" ,1,',',"array_out"
,quote_string,dequote_string,{0},2},
- {PG_GTSVECTORARRAY ,"_gtsvector" ,1,',',"array_out"
,quote_string,dequote_string,{0},0},
- {PG_INETARRAY ,"_inet" ,1,',',"array_out"
,quote_string,dequote_string,{0},0},
- {PG_INT2ARRAY ,"_int2" ,1,',',"array_out"
,quote_string,dequote_string,{0},1},
- {PG_INT2VECTORARRAY ,"_int2vector" ,1,',',"array_out"
,quote_string,dequote_string,{0},0},
- {PG_INT4ARRAY ,"_int4" ,1,',',"array_out"
,quote_string,dequote_string,{0},1},
- {PG_INT4RANGEARRAY ,"_int4range" ,1,',',"array_out"
,quote_string,dequote_string,{0},0},
- {PG_INT8ARRAY ,"_int8" ,1,',',"array_out"
,quote_string,dequote_string,{0},0},
- {PG_INT8RANGEARRAY ,"_int8range" ,1,',',"array_out"
,quote_string,dequote_string,{0},0},
- {PG_INTERVALARRAY ,"_interval" ,1,',',"array_out"
,quote_string,dequote_string,{0},0},
- {PG_JSONARRAY ,"_json" ,1,',',"array_out"
,quote_string,dequote_string,{0},0},
- {PG_LINEARRAY ,"_line" ,1,',',"array_out"
,quote_string,dequote_string,{0},0},
- {PG_LSEGARRAY ,"_lseg" ,1,',',"array_out"
,quote_string,dequote_string,{0},0},
- {PG_MACADDRARRAY ,"_macaddr" ,1,',',"array_out"
,quote_string,dequote_string,{0},0},
- {PG_MONEYARRAY ,"_money" ,1,',',"array_out"
,quote_string,dequote_string,{0},0},
- {PG_NAMEARRAY ,"_name" ,1,',',"array_out"
,quote_string,dequote_string,{0},0},
- {PG_NUMERICARRAY ,"_numeric" ,1,',',"array_out"
,quote_string,dequote_string,{0},2},
- {PG_NUMRANGEARRAY ,"_numrange" ,1,',',"array_out"
,quote_string,dequote_string,{0},0},
- {PG_OIDARRAY ,"_oid" ,1,',',"array_out"
,quote_string,dequote_string,{0},1},
- {PG_OIDVECTORARRAY ,"_oidvector" ,1,',',"array_out"
,quote_string,dequote_string,{0},0},
- {PG_PATHARRAY ,"_path" ,1,',',"array_out"
,quote_string,dequote_string,{0},0},
- {PG_POINTARRAY ,"_point" ,1,',',"array_out"
,quote_string,dequote_string,{0},0},
- {PG_POLYGONARRAY ,"_polygon" ,1,',',"array_out"
,quote_string,dequote_string,{0},0},
- {PG_RECORDARRAY ,"_record" ,1,',',"array_out"
,quote_string,dequote_string,{0},0},
- {PG_REFCURSORARRAY ,"_refcursor" ,1,',',"array_out"
,quote_string,dequote_string,{0},0},
- {PG_REGCLASSARRAY ,"_regclass" ,1,',',"array_out"
,quote_string,dequote_string,{0},0},
- {PG_REGCONFIGARRAY ,"_regconfig" ,1,',',"array_out"
,quote_string,dequote_string,{0},0},
- {PG_REGDICTIONARYARRAY,"_regdictionary" ,1,',',"array_out"
,quote_string,dequote_string,{0},0},
- {PG_REGOPERARRAY ,"_regoper" ,1,',',"array_out"
,quote_string,dequote_string,{0},0},
- {PG_REGOPERATORARRAY ,"_regoperator" ,1,',',"array_out"
,quote_string,dequote_string,{0},0},
- {PG_REGPROCARRAY ,"_regproc" ,1,',',"array_out"
,quote_string,dequote_string,{0},0},
- {PG_REGPROCEDUREARRAY ,"_regprocedure" ,1,',',"array_out"
,quote_string,dequote_string,{0},0},
- {PG_REGTYPEARRAY ,"_regtype" ,1,',',"array_out"
,quote_string,dequote_string,{0},0},
- {PG_RELTIMEARRAY ,"_reltime" ,1,',',"array_out"
,quote_string,dequote_string,{0},0},
- {PG_TEXTARRAY ,"_text" ,1,',',"array_out"
,quote_string,dequote_string,{0},0},
- {PG_TIDARRAY ,"_tid" ,1,',',"array_out"
,quote_string,dequote_string,{0},0},
- {PG_TIMEARRAY ,"_time" ,1,',',"array_out"
,quote_string,dequote_string,{0},0},
- {PG_TIMESTAMPARRAY ,"_timestamp" ,1,',',"array_out"
,quote_string,dequote_string,{0},0},
- {PG_TIMESTAMPTZARRAY ,"_timestamptz" ,1,',',"array_out"
,quote_string,dequote_string,{0},0},
- {PG_TIMETZARRAY ,"_timetz" ,1,',',"array_out"
,quote_string,dequote_string,{0},0},
- {PG_TINTERVALARRAY ,"_tinterval" ,1,',',"array_out"
,quote_string,dequote_string,{0},0},
- {PG_TSQUERYARRAY ,"_tsquery" ,1,',',"array_out"
,quote_string,dequote_string,{0},0},
- {PG_TSRANGEARRAY ,"_tsrange" ,1,',',"array_out"
,quote_string,dequote_string,{0},0},
- {PG_TSTZRANGEARRAY ,"_tstzrange" ,1,',',"array_out"
,quote_string,dequote_string,{0},0},
- {PG_TSVECTORARRAY ,"_tsvector" ,1,',',"array_out"
,quote_string,dequote_string,{0},0},
- {PG_TXID_SNAPSHOTARRAY,"_txid_snapshot" ,1,',',"array_out"
,quote_string,dequote_string,{0},0},
- {PG_UUIDARRAY ,"_uuid" ,1,',',"array_out"
,quote_string,dequote_string,{0},0},
- {PG_VARBITARRAY ,"_varbit" ,1,',',"array_out"
,quote_string,dequote_string,{0},0},
- {PG_VARCHARARRAY ,"_varchar" ,1,',',"array_out"
,quote_string,dequote_string,{0},0},
- {PG_XIDARRAY ,"_xid" ,1,',',"array_out"
,quote_string,dequote_string,{0},0},
- {PG_XMLARRAY ,"_xml" ,1,',',"array_out"
,quote_string,dequote_string,{0},0},
- {PG_ABSTIME ,"abstime" ,1,',',"abstimeout"
,quote_string,dequote_string,{0},0},
- {PG_ACLITEM ,"aclitem" ,1,',',"aclitemout"
,quote_string,dequote_string,{0},0},
- {PG_ANY ,"any" ,1,',',"any_out"
,quote_string,dequote_string,{0},0},
- {PG_ANYARRAY ,"anyarray" ,1,',',"anyarray_out"
,quote_string,dequote_string,{0},0},
- {PG_ANYELEMENT ,"anyelement" ,1,',',"anyelement_out"
,quote_string,dequote_string,{0},0},
- {PG_ANYENUM ,"anyenum" ,1,',',"anyenum_out"
,quote_string,dequote_string,{0},0},
- {PG_ANYNONARRAY ,"anynonarray" ,1,',',"anynonarray_out"
,quote_string,dequote_string,{0},0},
- {PG_ANYRANGE ,"anyrange" ,1,',',"anyrange_out"
,quote_string,dequote_string,{0},0},
- {PG_BIT ,"bit" ,1,',',"bit_out"
,quote_string,dequote_string,{0},0},
- {PG_BOOL ,"bool" ,1,',',"boolout"
,quote_bool ,dequote_bool ,{SQL_BOOLEAN},3},
- {PG_BOX ,"box" ,1,';',"box_out"
,quote_geom ,dequote_string,{0},0},
- {PG_BPCHAR ,"bpchar" ,1,',',"bpcharout"
,quote_string,dequote_char ,{SQL_CHAR},0},
- {PG_BYTEA ,"bytea" ,1,',',"byteaout"
,quote_bytea ,dequote_bytea ,{SQL_VARBINARY},0},
- {PG_CHAR ,"char" ,1,',',"charout"
,quote_string,dequote_char ,{SQL_CHAR},0},
- {PG_CID ,"cid" ,1,',',"cidout"
,quote_string,dequote_string,{0},0},
- {PG_CIDR ,"cidr" ,1,',',"cidr_out"
,quote_string,dequote_string,{0},0},
- {PG_CIRCLE ,"circle" ,1,',',"circle_out"
,quote_circle,dequote_string,{0},0},
- {PG_CSTRING ,"cstring" ,1,',',"cstring_out"
,quote_string,dequote_string,{0},0},
- {PG_DATE ,"date" ,1,',',"date_out"
,quote_string,dequote_string,{SQL_TYPE_DATE},0},
- {PG_DATERANGE ,"daterange" ,1,',',"range_out"
,quote_string,dequote_string,{0},0},
- {PG_EVENT_TRIGGER ,"event_trigger"
,1,',',"event_trigger_out",quote_string,dequote_string,{0},0},
- {PG_FDW_HANDLER ,"fdw_handler" ,1,',',"fdw_handler_out"
,quote_string,dequote_string,{0},0},
- {PG_FLOAT4 ,"float4" ,1,',',"float4out"
,quote_float ,null_dequote ,{0},2},
- {PG_FLOAT8 ,"float8" ,1,',',"float8out"
,quote_float ,null_dequote ,{SQL_FLOAT},2},
- {PG_GTSVECTOR ,"gtsvector" ,1,',',"gtsvectorout"
,quote_string,dequote_string,{0},0},
- {PG_INET ,"inet" ,1,',',"inet_out"
,quote_string,dequote_string,{0},0},
- {PG_INT2 ,"int2" ,1,',',"int2out" ,quote_int
,null_dequote ,{SQL_SMALLINT},1},
- {PG_INT2VECTOR ,"int2vector" ,1,',',"int2vectorout"
,quote_string,dequote_string,{0},0},
- {PG_INT4 ,"int4" ,1,',',"int4out" ,quote_int
,null_dequote ,{SQL_INTEGER},1},
- {PG_INT4RANGE ,"int4range" ,1,',',"range_out"
,quote_string,dequote_string,{0},0},
- {PG_INT8 ,"int8" ,1,',',"int8out" ,quote_int
,null_dequote ,{SQL_BIGINT},0},
- {PG_INT8RANGE ,"int8range" ,1,',',"range_out"
,quote_string,dequote_string,{0},0},
- {PG_INTERNAL ,"internal" ,1,',',"internal_out"
,quote_string,dequote_string,{0},0},
- {PG_INTERVAL ,"interval" ,1,',',"interval_out"
,quote_string,dequote_string,{0},0},
- {PG_JSON ,"json" ,1,',',"json_out"
,quote_string,dequote_string,{0},0},
+ {PG_ABSTIMEARRAY ,"_abstime" ,1,',',"array_out"
,quote_string,dequote_string,{0},0},
+ {PG_ACLITEMARRAY ,"_aclitem" ,1,',',"array_out"
,quote_string,dequote_string,{0},0},
+ {PG_BITARRAY ,"_bit" ,1,',',"array_out"
,quote_string,dequote_string,{0},0},
+ {PG_BOOLARRAY ,"_bool" ,1,',',"array_out"
,quote_string,dequote_string,{0},3},
+ {PG_BOXARRAY ,"_box" ,1,';',"array_out"
,quote_string,dequote_string,{0},0},
+ {PG_BPCHARARRAY ,"_bpchar" ,1,',',"array_out"
,quote_string,dequote_string,{0},0},
+ {PG_BYTEAARRAY ,"_bytea" ,1,',',"array_out"
,quote_string,dequote_string,{0},0},
+ {PG_CHARARRAY ,"_char" ,1,',',"array_out"
,quote_string,dequote_string,{0},0},
+ {PG_CIDARRAY ,"_cid" ,1,',',"array_out"
,quote_string,dequote_string,{0},0},
+ {PG_CIDRARRAY ,"_cidr" ,1,',',"array_out"
,quote_string,dequote_string,{0},0},
+ {PG_CIRCLEARRAY ,"_circle" ,1,',',"array_out"
,quote_string,dequote_string,{0},0},
+ {PG_CSTRINGARRAY ,"_cstring" ,1,',',"array_out"
,quote_string,dequote_string,{0},0},
+ {PG_DATEARRAY ,"_date" ,1,',',"array_out"
,quote_string,dequote_string,{0},0},
+ {PG_DATERANGEARRAY ,"_daterange" ,1,',',"array_out"
,quote_string,dequote_string,{0},0},
+ {PG_FLOAT4ARRAY ,"_float4" ,1,',',"array_out"
,quote_string,dequote_string,{0},2},
+ {PG_FLOAT8ARRAY ,"_float8" ,1,',',"array_out"
,quote_string,dequote_string,{0},2},
+ {PG_GTSVECTORARRAY ,"_gtsvector" ,1,',',"array_out"
,quote_string,dequote_string,{0},0},
+ {PG_INETARRAY ,"_inet" ,1,',',"array_out"
,quote_string,dequote_string,{0},0},
+ {PG_INT2ARRAY ,"_int2" ,1,',',"array_out"
,quote_string,dequote_string,{0},1},
+ {PG_INT2VECTORARRAY ,"_int2vector" ,1,',',"array_out"
,quote_string,dequote_string,{0},0},
+ {PG_INT4ARRAY ,"_int4" ,1,',',"array_out"
,quote_string,dequote_string,{0},1},
+ {PG_INT4RANGEARRAY ,"_int4range" ,1,',',"array_out"
,quote_string,dequote_string,{0},0},
+ {PG_INT8ARRAY ,"_int8" ,1,',',"array_out"
,quote_string,dequote_string,{0},0},
+ {PG_INT8RANGEARRAY ,"_int8range" ,1,',',"array_out"
,quote_string,dequote_string,{0},0},
+ {PG_INTERVALARRAY ,"_interval" ,1,',',"array_out"
,quote_string,dequote_string,{0},0},
+ {PG_JSONARRAY ,"_json" ,1,',',"array_out"
,quote_string,dequote_string,{0},0},
+ {PG_LINEARRAY ,"_line" ,1,',',"array_out"
,quote_string,dequote_string,{0},0},
+ {PG_LSEGARRAY ,"_lseg" ,1,',',"array_out"
,quote_string,dequote_string,{0},0},
+ {PG_MACADDRARRAY ,"_macaddr" ,1,',',"array_out"
,quote_string,dequote_string,{0},0},
+ {PG_MONEYARRAY ,"_money" ,1,',',"array_out"
,quote_string,dequote_string,{0},0},
+ {PG_NAMEARRAY ,"_name" ,1,',',"array_out"
,quote_string,dequote_string,{0},0},
+ {PG_NUMERICARRAY ,"_numeric" ,1,',',"array_out"
,quote_string,dequote_string,{0},2},
+ {PG_NUMRANGEARRAY ,"_numrange" ,1,',',"array_out"
,quote_string,dequote_string,{0},0},
+ {PG_OIDARRAY ,"_oid" ,1,',',"array_out"
,quote_string,dequote_string,{0},1},
+ {PG_OIDVECTORARRAY ,"_oidvector" ,1,',',"array_out"
,quote_string,dequote_string,{0},0},
+ {PG_PATHARRAY ,"_path" ,1,',',"array_out"
,quote_string,dequote_string,{0},0},
+ {PG_POINTARRAY ,"_point" ,1,',',"array_out"
,quote_string,dequote_string,{0},0},
+ {PG_POLYGONARRAY ,"_polygon" ,1,',',"array_out"
,quote_string,dequote_string,{0},0},
+ {PG_RECORDARRAY ,"_record" ,1,',',"array_out"
,quote_string,dequote_string,{0},0},
+ {PG_REFCURSORARRAY ,"_refcursor" ,1,',',"array_out"
,quote_string,dequote_string,{0},0},
+ {PG_REGCLASSARRAY ,"_regclass" ,1,',',"array_out"
,quote_string,dequote_string,{0},0},
+ {PG_REGCONFIGARRAY ,"_regconfig" ,1,',',"array_out"
,quote_string,dequote_string,{0},0},
+ {PG_REGDICTIONARYARRAY,"_regdictionary" ,1,',',"array_out"
,quote_string,dequote_string,{0},0},
+ {PG_REGOPERARRAY ,"_regoper" ,1,',',"array_out"
,quote_string,dequote_string,{0},0},
+ {PG_REGOPERATORARRAY ,"_regoperator" ,1,',',"array_out"
,quote_string,dequote_string,{0},0},
+ {PG_REGPROCARRAY ,"_regproc" ,1,',',"array_out"
,quote_string,dequote_string,{0},0},
+ {PG_REGPROCEDUREARRAY ,"_regprocedure" ,1,',',"array_out"
,quote_string,dequote_string,{0},0},
+ {PG_REGTYPEARRAY ,"_regtype" ,1,',',"array_out"
,quote_string,dequote_string,{0},0},
+ {PG_RELTIMEARRAY ,"_reltime" ,1,',',"array_out"
,quote_string,dequote_string,{0},0},
+ {PG_TEXTARRAY ,"_text" ,1,',',"array_out"
,quote_string,dequote_string,{0},0},
+ {PG_TIDARRAY ,"_tid" ,1,',',"array_out"
,quote_string,dequote_string,{0},0},
+ {PG_TIMEARRAY ,"_time" ,1,',',"array_out"
,quote_string,dequote_string,{0},0},
+ {PG_TIMESTAMPARRAY ,"_timestamp" ,1,',',"array_out"
,quote_string,dequote_string,{0},0},
+ {PG_TIMESTAMPTZARRAY ,"_timestamptz" ,1,',',"array_out"
,quote_string,dequote_string,{0},0},
+ {PG_TIMETZARRAY ,"_timetz" ,1,',',"array_out"
,quote_string,dequote_string,{0},0},
+ {PG_TINTERVALARRAY ,"_tinterval" ,1,',',"array_out"
,quote_string,dequote_string,{0},0},
+ {PG_TSQUERYARRAY ,"_tsquery" ,1,',',"array_out"
,quote_string,dequote_string,{0},0},
+ {PG_TSRANGEARRAY ,"_tsrange" ,1,',',"array_out"
,quote_string,dequote_string,{0},0},
+ {PG_TSTZRANGEARRAY ,"_tstzrange" ,1,',',"array_out"
,quote_string,dequote_string,{0},0},
+ {PG_TSVECTORARRAY ,"_tsvector" ,1,',',"array_out"
,quote_string,dequote_string,{0},0},
+ {PG_TXID_SNAPSHOTARRAY,"_txid_snapshot" ,1,',',"array_out"
,quote_string,dequote_string,{0},0},
+ {PG_UUIDARRAY ,"_uuid" ,1,',',"array_out"
,quote_string,dequote_string,{0},0},
+ {PG_VARBITARRAY ,"_varbit" ,1,',',"array_out"
,quote_string,dequote_string,{0},0},
+ {PG_VARCHARARRAY ,"_varchar" ,1,',',"array_out"
,quote_string,dequote_string,{0},0},
+ {PG_XIDARRAY ,"_xid" ,1,',',"array_out"
,quote_string,dequote_string,{0},0},
+ {PG_XMLARRAY ,"_xml" ,1,',',"array_out"
,quote_string,dequote_string,{0},0},
+ {PG_ABSTIME ,"abstime" ,1,',',"abstimeout"
,quote_string,dequote_string,{0},0},
+ {PG_ACLITEM ,"aclitem" ,1,',',"aclitemout"
,quote_string,dequote_string,{0},0},
+ {PG_ANY ,"any" ,1,',',"any_out"
,quote_string,dequote_string,{0},0},
+ {PG_ANYARRAY ,"anyarray" ,1,',',"anyarray_out"
,quote_string,dequote_string,{0},0},
+ {PG_ANYELEMENT ,"anyelement" ,1,',',"anyelement_out"
,quote_string,dequote_string,{0},0},
+ {PG_ANYENUM ,"anyenum" ,1,',',"anyenum_out"
,quote_string,dequote_string,{0},0},
+ {PG_ANYNONARRAY ,"anynonarray" ,1,',',"anynonarray_out"
,quote_string,dequote_string,{0},0},
+ {PG_ANYRANGE ,"anyrange" ,1,',',"anyrange_out"
,quote_string,dequote_string,{0},0},
+ {PG_BIT ,"bit" ,1,',',"bit_out"
,quote_string,dequote_string,{0},0},
+ {PG_BOOL ,"bool" ,1,',',"boolout"
,quote_bool ,dequote_bool ,{SQL_BOOLEAN},3},
+ {PG_BOX ,"box" ,1,';',"box_out"
,quote_geom ,dequote_string,{0},0},
+ {PG_BPCHAR ,"bpchar" ,1,',',"bpcharout"
,quote_string,dequote_char ,{SQL_CHAR},0},
+ {PG_BYTEA ,"bytea" ,1,',',"byteaout"
,quote_bytea ,dequote_bytea ,{SQL_VARBINARY},0},
+ {PG_CHAR ,"char" ,1,',',"charout"
,quote_string,dequote_char ,{SQL_CHAR},0},
+ {PG_CID ,"cid" ,1,',',"cidout"
,quote_string,dequote_string,{0},0},
+ {PG_CIDR ,"cidr" ,1,',',"cidr_out"
,quote_string,dequote_string,{0},0},
+ {PG_CIRCLE ,"circle" ,1,',',"circle_out"
,quote_circle,dequote_string,{0},0},
+ {PG_CSTRING ,"cstring" ,1,',',"cstring_out"
,quote_string,dequote_string,{0},0},
+ {PG_DATE ,"date" ,1,',',"date_out"
,quote_string,dequote_string,{SQL_TYPE_DATE},0},
+ {PG_DATERANGE ,"daterange" ,1,',',"range_out"
,quote_string,dequote_string,{0},0},
+ {PG_EVENT_TRIGGER ,"event_trigger" ,1,',',"event_trigger_out"
,quote_string,dequote_string,{0},0},
+ {PG_FDW_HANDLER ,"fdw_handler" ,1,',',"fdw_handler_out"
,quote_string,dequote_string,{0},0},
+ {PG_FLOAT4 ,"float4" ,1,',',"float4out"
,quote_float ,null_dequote ,{0},2},
+ {PG_FLOAT8 ,"float8" ,1,',',"float8out"
,quote_float ,null_dequote ,{SQL_FLOAT},2},
+ {PG_GTSVECTOR ,"gtsvector" ,1,',',"gtsvectorout"
,quote_string,dequote_string,{0},0},
+ {PG_INET ,"inet" ,1,',',"inet_out"
,quote_string,dequote_string,{0},0},
+ {PG_INT2 ,"int2" ,1,',',"int2out"
,quote_int ,null_dequote ,{SQL_SMALLINT},1},
+ {PG_INT2VECTOR ,"int2vector" ,1,',',"int2vectorout"
,quote_string,dequote_string,{0},0},
+ {PG_INT4 ,"int4" ,1,',',"int4out"
,quote_int ,null_dequote ,{SQL_INTEGER},1},
+ {PG_INT4RANGE ,"int4range" ,1,',',"range_out"
,quote_string,dequote_string,{0},0},
+ {PG_INT8 ,"int8" ,1,',',"int8out"
,quote_int ,null_dequote ,{SQL_BIGINT},0},
+ {PG_INT8RANGE ,"int8range" ,1,',',"range_out"
,quote_string,dequote_string,{0},0},
+ {PG_INTERNAL ,"internal" ,1,',',"internal_out"
,quote_string,dequote_string,{0},0},
+ {PG_INTERVAL ,"interval" ,1,',',"interval_out"
,quote_string,dequote_string,{0},0},
+ {PG_JSON ,"json" ,1,',',"json_out"
,quote_string,dequote_string,{0},0},
{PG_LANGUAGE_HANDLER ,"language_handler"
,1,',',"language_handler_out",quote_string,dequote_string,{0},0},
- {PG_LINE ,"line" ,1,',',"line_out"
,quote_geom ,dequote_string,{0},0},
- {PG_LSEG ,"lseg" ,1,',',"lseg_out"
,quote_geom ,dequote_string,{0},0},
- {PG_MACADDR ,"macaddr" ,1,',',"macaddr_out"
,quote_string,dequote_string,{0},0},
- {PG_MONEY ,"money" ,1,',',"cash_out"
,quote_string,dequote_string,{0},0},
- {PG_NAME ,"name" ,1,',',"nameout"
,quote_name ,null_dequote ,{SQL_VARCHAR},0},
- {PG_NUMERIC ,"numeric" ,1,',',"numeric_out"
,quote_float ,null_dequote ,{SQL_DECIMAL},2},
- {PG_NUMRANGE ,"numrange" ,1,',',"range_out"
,quote_string,dequote_string,{0},0},
- {PG_OID ,"oid" ,1,',',"oidout" ,quote_int
,null_dequote ,{0},1},
- {PG_OIDVECTOR ,"oidvector" ,1,',',"oidvectorout"
,quote_string,dequote_string,{0},0},
- {PG_OPAQUE ,"opaque" ,1,',',"opaque_out"
,quote_string,dequote_string,{0},0},
- {PG_PATH ,"path" ,1,',',"path_out"
,quote_path ,dequote_string,{0},0},
- {PG_PG_ATTRIBUTE ,"pg_attribute" ,1,',',"record_out"
,quote_string,dequote_string,{0},0},
- {PG_PG_CLASS ,"pg_class" ,1,',',"record_out"
,quote_string,dequote_string,{0},0},
- {PG_PG_NODE_TREE ,"pg_node_tree"
,1,',',"pg_node_tree_out",quote_string,dequote_string,{0},0},
- {PG_PG_PROC ,"pg_proc" ,1,',',"record_out"
,quote_string,dequote_string,{0},0},
- {PG_PG_TYPE ,"pg_type" ,1,',',"record_out"
,quote_string,dequote_string,{0},0},
- {PG_POINT ,"point" ,1,',',"point_out"
,quote_geom ,dequote_string,{0},0},
- {PG_POLYGON ,"polygon" ,1,',',"poly_out"
,quote_geom ,dequote_string,{0},0},
- {PG_RECORD ,"record" ,1,',',"record_out"
,quote_string,dequote_string,{0},0},
- {PG_REFCURSOR ,"refcursor" ,1,',',"textout"
,quote_string,dequote_string,{0},0},
- {PG_REGCLASS ,"regclass" ,1,',',"regclassout"
,quote_string,dequote_string,{0},0},
- {PG_REGCONFIG ,"regconfig" ,1,',',"regconfigout"
,quote_string,dequote_string,{0},0},
- {PG_REGDICTIONARY ,"regdictionary"
,1,',',"regdictionaryout",quote_string,dequote_string,{0},0},
- {PG_REGOPER ,"regoper" ,1,',',"regoperout"
,quote_string,dequote_string,{0},0},
- {PG_REGOPERATOR ,"regoperator" ,1,',',"regoperatorout"
,quote_string,dequote_string,{0},0},
- {PG_REGPROC ,"regproc" ,1,',',"regprocout"
,quote_string,dequote_string,{0},0},
- {PG_REGPROCEDURE ,"regprocedure" ,1,',',"regprocedureout"
,quote_string,dequote_string,{0},0},
- {PG_REGTYPE ,"regtype" ,1,',',"regtypeout"
,quote_string,dequote_string,{0},0},
- {PG_RELTIME ,"reltime" ,1,',',"reltimeout"
,quote_string,dequote_string,{0},0},
- {PG_SMGR ,"smgr" ,1,',',"smgrout"
,quote_string,dequote_string,{0},0},
- {PG_TEXT ,"text" ,1,',',"textout"
,quote_string,dequote_string,{SQL_LONGVARCHAR},0},
- {PG_TID ,"tid" ,1,',',"tidout"
,quote_geom ,dequote_string,{0},0},
- {PG_TIME ,"time" ,1,',',"time_out"
,quote_string,dequote_string,{SQL_TYPE_TIME},0},
- {PG_TIMESTAMP ,"timestamp" ,1,',',"timestamp_out"
,quote_string,dequote_string,{SQL_TIMESTAMP},0},
- {PG_TIMESTAMPTZ ,"timestamptz" ,1,',',"timestamptz_out"
,quote_string,dequote_string,{SQL_TYPE_TIMESTAMP_WITH_TIMEZONE},0},
- {PG_TIMETZ ,"timetz" ,1,',',"timetz_out"
,quote_string,dequote_string,{0},0},
- {PG_TINTERVAL ,"tinterval" ,1,',',"tintervalout"
,quote_string,dequote_string,{0},0},
- {PG_TRIGGER ,"trigger" ,1,',',"trigger_out"
,quote_string,dequote_string,{0},0},
- {PG_TSQUERY ,"tsquery" ,1,',',"tsqueryout"
,quote_string,dequote_string,{0},0},
- {PG_TSRANGE ,"tsrange" ,1,',',"range_out"
,quote_string,dequote_string,{0},0},
- {PG_TSTZRANGE ,"tstzrange" ,1,',',"range_out"
,quote_string,dequote_string,{0},0},
- {PG_TSVECTOR ,"tsvector" ,1,',',"tsvectorout"
,quote_string,dequote_string,{0},0},
- {PG_TXID_SNAPSHOT ,"txid_snapshot"
,1,',',"txid_snapshot_out",quote_string,dequote_string,{0},0},
- {PG_UNKNOWN ,"unknown" ,1,',',"unknownout"
,quote_string,dequote_string,{0},0},
- {PG_UUID ,"uuid" ,1,',',"uuid_out"
,quote_string,dequote_string,{0},0},
- {PG_VARBIT ,"varbit" ,1,',',"varbit_out"
,quote_string,dequote_string,{0},0},
- {PG_VARCHAR ,"varchar" ,1,',',"varcharout"
,quote_string,dequote_string,{SQL_VARCHAR},0},
- {PG_VOID ,"void" ,1,',',"void_out"
,quote_string,dequote_string,{0},0},
- {PG_XID ,"xid" ,1,',',"xidout"
,quote_string,dequote_string,{0},0},
- {PG_XML ,"xml" ,1,',',"xml_out"
,quote_string,dequote_string,{0},0},
+ {PG_LINE ,"line" ,1,',',"line_out"
,quote_geom ,dequote_string,{0},0},
+ {PG_LSEG ,"lseg" ,1,',',"lseg_out"
,quote_geom ,dequote_string,{0},0},
+ {PG_MACADDR ,"macaddr" ,1,',',"macaddr_out"
,quote_string,dequote_string,{0},0},
+ {PG_MONEY ,"money" ,1,',',"cash_out"
,quote_string,dequote_string,{0},0},
+ {PG_NAME ,"name" ,1,',',"nameout"
,quote_name ,null_dequote ,{SQL_VARCHAR},0},
+ {PG_NUMERIC ,"numeric" ,1,',',"numeric_out"
,quote_float ,null_dequote ,{SQL_DECIMAL},2},
+ {PG_NUMRANGE ,"numrange" ,1,',',"range_out"
,quote_string,dequote_string,{0},0},
+ {PG_OID ,"oid" ,1,',',"oidout"
,quote_int ,null_dequote ,{0},1},
+ {PG_OIDVECTOR ,"oidvector" ,1,',',"oidvectorout"
,quote_string,dequote_string,{0},0},
+ {PG_OPAQUE ,"opaque" ,1,',',"opaque_out"
,quote_string,dequote_string,{0},0},
+ {PG_PATH ,"path" ,1,',',"path_out"
,quote_path ,dequote_string,{0},0},
+ {PG_PG_ATTRIBUTE ,"pg_attribute" ,1,',',"record_out"
,quote_string,dequote_string,{0},0},
+ {PG_PG_CLASS ,"pg_class" ,1,',',"record_out"
,quote_string,dequote_string,{0},0},
+ {PG_PG_NODE_TREE ,"pg_node_tree" ,1,',',"pg_node_tree_out"
,quote_string,dequote_string,{0},0},
+ {PG_PG_PROC ,"pg_proc" ,1,',',"record_out"
,quote_string,dequote_string,{0},0},
+ {PG_PG_TYPE ,"pg_type" ,1,',',"record_out"
,quote_string,dequote_string,{0},0},
+ {PG_POINT ,"point" ,1,',',"point_out"
,quote_geom ,dequote_string,{0},0},
+ {PG_POLYGON ,"polygon" ,1,',',"poly_out"
,quote_geom ,dequote_string,{0},0},
+ {PG_RECORD ,"record" ,1,',',"record_out"
,quote_string,dequote_string,{0},0},
+ {PG_REFCURSOR ,"refcursor" ,1,',',"textout"
,quote_string,dequote_string,{0},0},
+ {PG_REGCLASS ,"regclass" ,1,',',"regclassout"
,quote_string,dequote_string,{0},0},
+ {PG_REGCONFIG ,"regconfig" ,1,',',"regconfigout"
,quote_string,dequote_string,{0},0},
+ {PG_REGDICTIONARY ,"regdictionary" ,1,',',"regdictionaryout"
,quote_string,dequote_string,{0},0},
+ {PG_REGOPER ,"regoper" ,1,',',"regoperout"
,quote_string,dequote_string,{0},0},
+ {PG_REGOPERATOR ,"regoperator" ,1,',',"regoperatorout"
,quote_string,dequote_string,{0},0},
+ {PG_REGPROC ,"regproc" ,1,',',"regprocout"
,quote_string,dequote_string,{0},0},
+ {PG_REGPROCEDURE ,"regprocedure" ,1,',',"regprocedureout"
,quote_string,dequote_string,{0},0},
+ {PG_REGTYPE ,"regtype" ,1,',',"regtypeout"
,quote_string,dequote_string,{0},0},
+ {PG_RELTIME ,"reltime" ,1,',',"reltimeout"
,quote_string,dequote_string,{0},0},
+ {PG_SMGR ,"smgr" ,1,',',"smgrout"
,quote_string,dequote_string,{0},0},
+ {PG_TEXT ,"text" ,1,',',"textout"
,quote_string,dequote_string,{SQL_LONGVARCHAR},0},
+ {PG_TID ,"tid" ,1,',',"tidout"
,quote_geom ,dequote_string,{0},0},
+ {PG_TIME ,"time" ,1,',',"time_out"
,quote_string,dequote_string,{SQL_TYPE_TIME},0},
+ {PG_TIMESTAMP ,"timestamp" ,1,',',"timestamp_out"
,quote_string,dequote_string,{SQL_TIMESTAMP},0},
+ {PG_TIMESTAMPTZ ,"timestamptz" ,1,',',"timestamptz_out"
,quote_string,dequote_string,{SQL_TYPE_TIMESTAMP_WITH_TIMEZONE},0},
+ {PG_TIMETZ ,"timetz" ,1,',',"timetz_out"
,quote_string,dequote_string,{0},0},
+ {PG_TINTERVAL ,"tinterval" ,1,',',"tintervalout"
,quote_string,dequote_string,{0},0},
+ {PG_TRIGGER ,"trigger" ,1,',',"trigger_out"
,quote_string,dequote_string,{0},0},
+ {PG_TSQUERY ,"tsquery" ,1,',',"tsqueryout"
,quote_string,dequote_string,{0},0},
+ {PG_TSRANGE ,"tsrange" ,1,',',"range_out"
,quote_string,dequote_string,{0},0},
+ {PG_TSTZRANGE ,"tstzrange" ,1,',',"range_out"
,quote_string,dequote_string,{0},0},
+ {PG_TSVECTOR ,"tsvector" ,1,',',"tsvectorout"
,quote_string,dequote_string,{0},0},
+ {PG_TXID_SNAPSHOT ,"txid_snapshot" ,1,',',"txid_snapshot_out"
,quote_string,dequote_string,{0},0},
+ {PG_UNKNOWN ,"unknown" ,1,',',"unknownout"
,quote_string,dequote_string,{0},0},
+ {PG_UUID ,"uuid" ,1,',',"uuid_out"
,quote_string,dequote_string,{0},0},
+ {PG_VARBIT ,"varbit" ,1,',',"varbit_out"
,quote_string,dequote_string,{0},0},
+ {PG_VARCHAR ,"varchar" ,1,',',"varcharout"
,quote_string,dequote_string,{SQL_VARCHAR},0},
+ {PG_VOID ,"void" ,1,',',"void_out"
,quote_string,dequote_string,{0},0},
+ {PG_XID ,"xid" ,1,',',"xidout"
,quote_string,dequote_string,{0},0},
+ {PG_XML ,"xml" ,1,',',"xml_out"
,quote_string,dequote_string,{0},0},
};
sql_type_info_t* pg_type_data(int sql_type)
@@ -682,7 +682,7 @@ for my $name (sort {$a cmp $b } keys %pgtype) {
my ($sqltype,$quote,$dequote) = (0,0,0);
(my $sql = $t->{sql}) =~ s{^(\w+).*}{$1};
- printf $newfh qq! {%-*s,%-*s,%d,'%s',%-18s,%-12s,%-14s,\{%s\},%d\},\n!,
+ printf $newfh qq! {%-*s,%-*s,%d,'%s',%-22s,%-12s,%-14s,\{%s\},%d\},\n!,
$maxlen, $t->{define}, $maxlen-2, "\"$name\"", 1, $t->{delim},
"\"$t->{textout}\"", $t->{quote}, $t->{dequote}, $sql, $t->{svtype};
$pos{$name} = $item++;
}
--
1.8.4
