Module: SqlPostgres::Select::Types

Defined in:

lib/sqlpostgres/Select.rb

Overview

OIDs for Postgresql data types. These must match postgresql/server/catalog/pg_type.h.

Constant Summary

BOOLEAN =

16

BYTEA =

17

QCHAR =

18

NAME =

19

BIGINT =

INT8 = BIGSERIAL = SERIAL8 = 20

SMALLINT =

21

INTEGER =

INT = INT4 = SERIAL = 23

TEXT =

25

OID =

26

POINT =

600

LSEG =

601

PATH =

602

BOX =

603

POLYGON =

604

CIDR =

650

ARRAY_CIDR =

651

REAL =

700

DOUBLE_PRECISION =

FLOAT8 = 701

UNKNOWN =

705

CIRCLE =

718

ARRAY_CIRCLE =

719

MACADDR =

829

INET =

869

ARRAY_BOOLEAN =

1000

ARRAY_BYTEA =

1001

ARRAY_QCHAR =

1002

ARRAY_NAME =

1003

ARRAY_SMALLINT =

1005

ARRAY_INTEGER =

1007

ARRAY_TEXT =

1009

ARRAY_CHARACTER =

1014

ARRAY_VARCHAR =

1015

ARRAY_BIGINT =

1016

ARRAY_POINT =

1017

ARRAY_LSEG =

1018

ARRAY_PATH =

1019

ARRAY_BOX =

1020

ARRAY_REAL =

1021

ARRAY_DOUBLE_PRECISION =

1022

ARRAY_POLYGON =

1027

ARRAY_MACADDR =

1040

ARRAY_INET =

1041

CHARACTER =

CHAR = 1042

VARCHAR =

CHARACTER_VARYING = 1043

DATE =

1082

TIME =

1083

TIMESTAMP =

TIMESTAMP_WITHOUT_TIME_ZONE = 1114

ARRAY_TIMESTAMP =

1115

ARRAY_DATE =

1182

ARRAY_TIME =

1183

TIMESTAMP_WITH_TIME_ZONE =

1184

ARRAY_TIMESTAMP_WITH_TIME_ZONE =

1185

INTERVAL =

1186

ARRAY_INTERVAL =

1187

ARRAY_NUMERIC =

1231

TIME_WITH_TIME_ZONE =

1266

ARRAY_TIME_WITH_TIME_ZONE =

1270

BIT =

1560

ARRAY_BIT =

1561

VARBIT =

1562

ARRAY_VARBIT =

1563

NUMERIC =

DECIMAL = 1700