DBD-KB

 view release on metacpan or  search on metacpan

types.c  view on Meta::CPAN


/*
    Please do not edit the C portions of this file directly. 
    It is automatically generated by the enclosed Perl script.
*/

#include "KB.h"

static sql_type_info_t pg_types[] = {
 {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_DATEMULTIRANGEARRAY           ,"_datemultirange"              ,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_INT4MULTIRANGEARRAY           ,"_int4multirange"              ,1,',',"array_out"           ,quote_string,dequote_string,{0},0},
 {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_INT8MULTIRANGEARRAY           ,"_int8multirange"              ,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_JSONBARRAY                    ,"_jsonb"                       ,1,',',"array_out"           ,quote_string,dequote_string,{0},0},
 {PG_JSONPATHARRAY                 ,"_jsonpath"                    ,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_MACADDR8ARRAY                 ,"_macaddr8"                    ,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_NUMMULTIRANGEARRAY            ,"_nummultirange"               ,1,',',"array_out"           ,quote_string,dequote_string,{0},0},
 {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_PG_ATTRIBUTEARRAY             ,"_pg_attribute"                ,1,',',"array_out"           ,quote_string,dequote_string,{0},0},
 {PG_PG_CLASSARRAY                 ,"_pg_class"                    ,1,',',"array_out"           ,quote_string,dequote_string,{0},0},
 {PG_PG_LSNARRAY                   ,"_pg_lsn"                      ,1,',',"array_out"           ,quote_string,dequote_string,{0},0},
 {PG_PG_PROCARRAY                  ,"_pg_proc"                     ,1,',',"array_out"           ,quote_string,dequote_string,{0},0},
 {PG_PG_SNAPSHOTARRAY              ,"_pg_snapshot"                 ,1,',',"array_out"           ,quote_string,dequote_string,{0},0},
 {PG_PG_TYPEARRAY                  ,"_pg_type"                     ,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_REGCOLLATIONARRAY             ,"_regcollation"                ,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_REGNAMESPACEARRAY             ,"_regnamespace"                ,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_REGROLEARRAY                  ,"_regrole"                     ,1,',',"array_out"           ,quote_string,dequote_string,{0},0},
 {PG_REGTYPEARRAY                  ,"_regtype"                     ,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_TSMULTIRANGEARRAY             ,"_tsmultirange"                ,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_TSTZMULTIRANGEARRAY           ,"_tstzmultirange"              ,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_XID8ARRAY                     ,"_xid8"                        ,1,',',"array_out"           ,quote_string,dequote_string,{0},0},
 {PG_XMLARRAY                      ,"_xml"                         ,1,',',"array_out"           ,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_ANYCOMPATIBLE                 ,"anycompatible"                ,1,',',"anycompatible_out"   ,quote_string,dequote_string,{0},0},
 {PG_ANYCOMPATIBLEARRAY            ,"anycompatiblearray"           ,1,',',"anycompatiblearray_out",quote_string,dequote_string,{0},0},
 {PG_ANYCOMPATIBLEMULTIRANGE       ,"anycompatiblemultirange"      ,1,',',"anycompatiblemultirange_out",quote_string,dequote_string,{0},0},
 {PG_ANYCOMPATIBLENONARRAY         ,"anycompatiblenonarray"        ,1,',',"anycompatiblenonarray_out",quote_string,dequote_string,{0},0},
 {PG_ANYCOMPATIBLERANGE            ,"anycompatiblerange"           ,1,',',"anycompatiblerange_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_ANYMULTIRANGE                 ,"anymultirange"                ,1,',',"anymultirange_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_DATEMULTIRANGE                ,"datemultirange"               ,1,',',"multirange_out"      ,quote_string,dequote_string,{0},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_INDEX_AM_HANDLER              ,"index_am_handler"             ,1,',',"index_am_handler_out",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_INT4MULTIRANGE                ,"int4multirange"               ,1,',',"multirange_out"      ,quote_string,dequote_string,{0},0},
 {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_INT8MULTIRANGE                ,"int8multirange"               ,1,',',"multirange_out"      ,quote_string,dequote_string,{0},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_JSONB                         ,"jsonb"                        ,1,',',"jsonb_out"           ,quote_string,dequote_string,{0},0},
 {PG_JSONPATH                      ,"jsonpath"                     ,1,',',"jsonpath_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_MACADDR8                      ,"macaddr8"                     ,1,',',"macaddr8_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_NUMERIC},2},
 {PG_NUMMULTIRANGE                 ,"nummultirange"                ,1,',',"multirange_out"      ,quote_string,dequote_string,{0},0},
 {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_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_BRIN_BLOOM_SUMMARY         ,"pg_brin_bloom_summary"        ,1,',',"brin_bloom_summary_out",quote_string,dequote_string,{0},0},
 {PG_PG_BRIN_MINMAX_MULTI_SUMMARY  ,"pg_brin_minmax_multi_summary" ,1,',',"brin_minmax_multi_summary_out",quote_string,dequote_string,{0},0},
 {PG_PG_CLASS                      ,"pg_class"                     ,1,',',"record_out"          ,quote_string,dequote_string,{0},0},
 {PG_PG_DDL_COMMAND                ,"pg_ddl_command"               ,1,',',"pg_ddl_command_out"  ,quote_string,dequote_string,{0},0},
 {PG_PG_DEPENDENCIES               ,"pg_dependencies"              ,1,',',"pg_dependencies_out" ,quote_string,dequote_string,{0},0},
 {PG_PG_LSN                        ,"pg_lsn"                       ,1,',',"pg_lsn_out"          ,quote_string,dequote_string,{0},0},
 {PG_PG_MCV_LIST                   ,"pg_mcv_list"                  ,1,',',"pg_mcv_list_out"     ,quote_string,dequote_string,{0},0},
 {PG_PG_NDISTINCT                  ,"pg_ndistinct"                 ,1,',',"pg_ndistinct_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_SNAPSHOT                   ,"pg_snapshot"                  ,1,',',"pg_snapshot_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_REGCOLLATION                  ,"regcollation"                 ,1,',',"regcollationout"     ,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_REGNAMESPACE                  ,"regnamespace"                 ,1,',',"regnamespaceout"     ,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_REGROLE                       ,"regrole"                      ,1,',',"regroleout"          ,quote_string,dequote_string,{0},0},
 {PG_REGTYPE                       ,"regtype"                      ,1,',',"regtypeout"          ,quote_string,dequote_string,{0},0},
 {PG_TABLE_AM_HANDLER              ,"table_am_handler"             ,1,',',"table_am_handler_out",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_TRIGGER                       ,"trigger"                      ,1,',',"trigger_out"         ,quote_string,dequote_string,{0},0},
 {PG_TSM_HANDLER                   ,"tsm_handler"                  ,1,',',"tsm_handler_out"     ,quote_string,dequote_string,{0},0},
 {PG_TSMULTIRANGE                  ,"tsmultirange"                 ,1,',',"multirange_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_TSTZMULTIRANGE                ,"tstzmultirange"               ,1,',',"multirange_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_XID8                          ,"xid8"                         ,1,',',"xid8out"             ,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)
{
    switch(sql_type) {

        case PG_ACLITEMARRAY:                   return &pg_types[0];
        case PG_BITARRAY:                       return &pg_types[1];
        case PG_BOOLARRAY:                      return &pg_types[2];
        case PG_BOXARRAY:                       return &pg_types[3];
        case PG_BPCHARARRAY:                    return &pg_types[4];
        case PG_BYTEAARRAY:                     return &pg_types[5];
        case PG_CHARARRAY:                      return &pg_types[6];
        case PG_CIDARRAY:                       return &pg_types[7];
        case PG_CIDRARRAY:                      return &pg_types[8];
        case PG_CIRCLEARRAY:                    return &pg_types[9];
        case PG_CSTRINGARRAY:                   return &pg_types[10];
        case PG_DATEARRAY:                      return &pg_types[11];
        case PG_DATEMULTIRANGEARRAY:            return &pg_types[12];
        case PG_DATERANGEARRAY:                 return &pg_types[13];
        case PG_FLOAT4ARRAY:                    return &pg_types[14];
        case PG_FLOAT8ARRAY:                    return &pg_types[15];
        case PG_GTSVECTORARRAY:                 return &pg_types[16];
        case PG_INETARRAY:                      return &pg_types[17];
        case PG_INT2ARRAY:                      return &pg_types[18];



( run in 0.698 second using v1.01-cache-2.11-cpan-39bf76dae61 )