Skip to content

TAPType

enumeration TAPType

Allowable types for TAP columns - The various definitions for these can be found in the VOTable,VOSI and ADQL specifications TAPTypeBOOLEANSMALLINTINTEGERBIGINTREALDOUBLETIMESTAMPCHARVARCHARBINARYVARBINARYCLOBBLOBPOINTREGIONCIRCLEELLIPSEBOXPOLYGONLINE

Values

  • BOOLEAN-true/false values

  • SMALLINT-typically a 16 bit integer

  • INTEGER-typically a 32 bit integer

  • BIGINT-typically a 64 bit integer

  • REAL-single precision floating point number

  • DOUBLE-double precision floating point number

  • TIMESTAMP-a timestamp in ISO 8601 format

  • CHAR-fixed length character

  • VARCHAR-variable length character

  • BINARY-fixed length binary

  • VARBINARY-variable length binary

  • CLOB-large character/text object. The actual size limit is implementation defined

  • BLOB-large binary object

  • POINT-Geometry values are two-dimensional; they are usually longitude and latitude values in spherical coordinates

  • REGION-FIXME this is a placeholder for the ADQL REGION type - we need to define how this is represented in TAP and VOTable and PGSphere

  • CIRCLE-a circular region

  • ELLIPSE-elliptical region

  • BOX-a box region

  • POLYGON-a polygon region

  • LINE-a line