Top Description Fields Constructors Methods
org.hsqldb.server

public Class PgType

extends Object
Class Inheritance
Imports
java.sql.SQLException, org.hsqldb.HsqlException, .Session, org.hsqldb.jdbc.JDBCUtil, org.hsqldb.types.Type, .Types
Postgres types.
Author
Blaine Simpson (blaine dot simpson at admc dot com)
Since
1.9.0

Field Summary

Modifier and TypeField and Description
protected static final PgType
bitSingleton

protected static final PgType
bitVaryingSingleton

protected static final PgType
boolSingleton

protected static final PgType
dateSingleton

protected static final PgType
daySecIntervalSingleton

protected static final PgType
doubleSingleton

protected static final PgType
hourSecIntervalSingleton

private Type
hType

protected static final PgType
int2singleton

protected static final PgType
int4singleton

protected static final PgType
int8singleton

private int
lpConstraint

protected static final PgType
minSecIntervalSingleton

private int
oid

protected static final PgType
secIntervalSingleton

protected static final PgType
textSingleton

protected static final PgType
tinyIntSingleton

public static final int
TYPE_ABSTIME

public static final int
TYPE_BIT

public static final int
TYPE_BLOB

public static final int
TYPE_BOOL

public static final int
TYPE_BOX

public static final int
TYPE_BPCHAR

public static final int
TYPE_BPCHARARRAY

public static final int
TYPE_BYTEA

public static final int
TYPE_CHAR

public static final int
TYPE_CHAR2

public static final int
TYPE_CHAR4

public static final int
TYPE_CHAR8

public static final int
TYPE_CID

public static final int
TYPE_CIDR

public static final int
TYPE_DATE

public static final int
TYPE_DATETIME

public static final int
TYPE_FILENAME

public static final int
TYPE_FLOAT4

public static final int
TYPE_FLOAT8

public static final int
TYPE_INET

public static final int
TYPE_INT2

public static final int
TYPE_INT2VECTOR

public static final int
TYPE_INT4

public static final int
TYPE_INT8

public static final int
TYPE_LSEG

public static final int
TYPE_MACADDR

public static final int
TYPE_MONEY

public static final int
TYPE_NAME

public static final int
TYPE_NUMERIC

public static final int
TYPE_OID

public static final int
TYPE_OIDINT2

public static final int
TYPE_OIDINT4

public static final int
TYPE_OIDNAME

public static final int
TYPE_OIDVECTOR

public static final int
TYPE_PATH

public static final int
TYPE_POINT

public static final int
TYPE_POLYGON

public static final int
TYPE_RECORD

public static final int
TYPE_REGPROC

public static final int
TYPE_RELTIME

public static final int
TYPE_SET

public static final int
TYPE_TEXT

public static final int
TYPE_TEXTARRAY

public static final int
TYPE_TID

public static final int
TYPE_TIME

public static final int
TYPE_TIME_WITH_TMZONE

public static final int
TYPE_TIMESTAMP

public static final int
TYPE_TIMESTAMP_NO_TMZONE

public static final int
TYPE_TINTERVAL

public static final int
TYPE_TINYINT

public static final int
TYPE_UNKNOWN

public static final int
TYPE_UUID

public static final int
TYPE_VARBIT

public static final int
TYPE_VARCHAR

public static final int
TYPE_VARCHARARRAY

public static final int
TYPE_VOID

public static final int
TYPE_XID

public static final int
TYPE_XML

public static final int
TYPE_XMLARRAY

private int
typeWidth

protected static final PgType
unknownSingleton

Constructor Summary

AccessConstructor and Description
protected
PgType(Type hType, int oid)

Convenience wrapper for PgType constructor, when there is no type width, length, or precision setting for the type.

protected
PgType(Type hType, int oid, int typeWidth)

Convenience wrapper for PgType constructor, when there is no length or precision setting for the type.

protected
PgType(Type hType, int oid, Integer
Normally pass null. This is a dummy parameter just to make a unique method signature. If non-null, will be treated exactly the same as the typeWidthObject from the 3-param constructor.
dummy, long lpConstraint)

Convenience wrapper for PgType constructor, when there is no fixed width for the type.

protected
PgType(Type
HyperSQL data type
hType, int
Numeric Object ID for the driver-side type.
oid, Integer
Fixed width for the type
typeWidthObject, Integer
Either length or Precision setting for this instance of the type

Important Note

for all types with positive lpConstraint other than Timestamps and Times, add an extra 4 to satisfy crazy driver protocol.

lpConstraintObject)

Method Summary

Modifier and TypeMethod and Description
public int
getLPConstraint()

public int
getOid()

public Object

Returns:

Object
getParameter(String
String
inString, Session
Session
session)

This method copied from JDBCPreparedStatement.java.

public static PgType
getPgType(Type hType)

public int
getTypeWidth()

private static void
ignoredConstraintWarning(Type hsqldbType)

pack-priv static void
throwError(HsqlException e)

public String
valueString(Object datum)

Inherited from java.lang.Object:
cloneequalsfinalizegetClasshashCodenotifynotifyAlltoStringwaitwaitwait

Field Detail

bitSingletonback to summary
protected static final PgType bitSingleton
bitVaryingSingletonback to summary
protected static final PgType bitVaryingSingleton
boolSingletonback to summary
protected static final PgType boolSingleton
dateSingletonback to summary
protected static final PgType dateSingleton
daySecIntervalSingletonback to summary
protected static final PgType daySecIntervalSingleton
doubleSingletonback to summary
protected static final PgType doubleSingleton
hourSecIntervalSingletonback to summary
protected static final PgType hourSecIntervalSingleton
hTypeback to summary
private Type hType
int2singletonback to summary
protected static final PgType int2singleton
int4singletonback to summary
protected static final PgType int4singleton
int8singletonback to summary
protected static final PgType int8singleton
lpConstraintback to summary
private int lpConstraint
minSecIntervalSingletonback to summary
protected static final PgType minSecIntervalSingleton
oidback to summary
private int oid
secIntervalSingletonback to summary
protected static final PgType secIntervalSingleton
textSingletonback to summary
protected static final PgType textSingleton
tinyIntSingletonback to summary
protected static final PgType tinyIntSingleton
TYPE_ABSTIMEback to summary
public static final int TYPE_ABSTIME
TYPE_BITback to summary
public static final int TYPE_BIT
TYPE_BLOBback to summary
public static final int TYPE_BLOB
TYPE_BOOLback to summary
public static final int TYPE_BOOL
TYPE_BOXback to summary
public static final int TYPE_BOX
TYPE_BPCHARback to summary
public static final int TYPE_BPCHAR
TYPE_BPCHARARRAYback to summary
public static final int TYPE_BPCHARARRAY
TYPE_BYTEAback to summary
public static final int TYPE_BYTEA
TYPE_CHARback to summary
public static final int TYPE_CHAR
TYPE_CHAR2back to summary
public static final int TYPE_CHAR2
TYPE_CHAR4back to summary
public static final int TYPE_CHAR4
TYPE_CHAR8back to summary
public static final int TYPE_CHAR8
TYPE_CIDback to summary
public static final int TYPE_CID
TYPE_CIDRback to summary
public static final int TYPE_CIDR
TYPE_DATEback to summary
public static final int TYPE_DATE
TYPE_DATETIMEback to summary
public static final int TYPE_DATETIME
TYPE_FILENAMEback to summary
public static final int TYPE_FILENAME
TYPE_FLOAT4back to summary
public static final int TYPE_FLOAT4
TYPE_FLOAT8back to summary
public static final int TYPE_FLOAT8
TYPE_INETback to summary
public static final int TYPE_INET
TYPE_INT2back to summary
public static final int TYPE_INT2
TYPE_INT2VECTORback to summary
public static final int TYPE_INT2VECTOR
TYPE_INT4back to summary
public static final int TYPE_INT4
TYPE_INT8back to summary
public static final int TYPE_INT8
TYPE_LSEGback to summary
public static final int TYPE_LSEG
TYPE_MACADDRback to summary
public static final int TYPE_MACADDR
TYPE_MONEYback to summary
public static final int TYPE_MONEY
TYPE_NAMEback to summary
public static final int TYPE_NAME
TYPE_NUMERICback to summary
public static final int TYPE_NUMERIC
TYPE_OIDback to summary
public static final int TYPE_OID
TYPE_OIDINT2back to summary
public static final int TYPE_OIDINT2
TYPE_OIDINT4back to summary
public static final int TYPE_OIDINT4
TYPE_OIDNAMEback to summary
public static final int TYPE_OIDNAME
TYPE_OIDVECTORback to summary
public static final int TYPE_OIDVECTOR
TYPE_PATHback to summary
public static final int TYPE_PATH
TYPE_POINTback to summary
public static final int TYPE_POINT
TYPE_POLYGONback to summary
public static final int TYPE_POLYGON
TYPE_RECORDback to summary
public static final int TYPE_RECORD
TYPE_REGPROCback to summary
public static final int TYPE_REGPROC
TYPE_RELTIMEback to summary
public static final int TYPE_RELTIME
TYPE_SETback to summary
public static final int TYPE_SET
TYPE_TEXTback to summary
public static final int TYPE_TEXT
TYPE_TEXTARRAYback to summary
public static final int TYPE_TEXTARRAY
TYPE_TIDback to summary
public static final int TYPE_TID
TYPE_TIMEback to summary
public static final int TYPE_TIME
TYPE_TIME_WITH_TMZONEback to summary
public static final int TYPE_TIME_WITH_TMZONE
TYPE_TIMESTAMPback to summary
public static final int TYPE_TIMESTAMP
TYPE_TIMESTAMP_NO_TMZONEback to summary
public static final int TYPE_TIMESTAMP_NO_TMZONE
TYPE_TINTERVALback to summary
public static final int TYPE_TINTERVAL
TYPE_TINYINTback to summary
public static final int TYPE_TINYINT
TYPE_UNKNOWNback to summary
public static final int TYPE_UNKNOWN
TYPE_UUIDback to summary
public static final int TYPE_UUID
TYPE_VARBITback to summary
public static final int TYPE_VARBIT
TYPE_VARCHARback to summary
public static final int TYPE_VARCHAR
TYPE_VARCHARARRAYback to summary
public static final int TYPE_VARCHARARRAY
TYPE_VOIDback to summary
public static final int TYPE_VOID
TYPE_XIDback to summary
public static final int TYPE_XID
TYPE_XMLback to summary
public static final int TYPE_XML
TYPE_XMLARRAYback to summary
public static final int TYPE_XMLARRAY
typeWidthback to summary
private int typeWidth
unknownSingletonback to summary
protected static final PgType unknownSingleton

Constructor Detail

PgTypeback to summary
protected PgType(Type hType, int oid)

Convenience wrapper for PgType constructor, when there is no type width, length, or precision setting for the type.

See Also
PgType(Type, int, Integer, Integer)
PgTypeback to summary
protected PgType(Type hType, int oid, int typeWidth)

Convenience wrapper for PgType constructor, when there is no length or precision setting for the type.

See Also
PgType(Type, int, Integer, Integer)
PgTypeback to summary
protected PgType(Type hType, int oid, Integer dummy, long lpConstraint) throws RecoverableOdbcFailure

Convenience wrapper for PgType constructor, when there is no fixed width for the type.

Parameters
dummy:Integer

Normally pass null. This is a dummy parameter just to make a unique method signature. If non-null, will be treated exactly the same as the typeWidthObject from the 3-param constructor.

See Also
PgType(Type, int, Integer, Integer)
PgTypeback to summary
protected PgType(Type hType, int oid, Integer typeWidthObject, Integer lpConstraintObject)
Parameters
hType:Type

HyperSQL data type

oid:int

Numeric Object ID for the driver-side type.

typeWidthObject:Integer

Fixed width for the type

lpConstraintObject:Integer

Either length or Precision setting for this instance of the type

Important Note

for all types with positive lpConstraint other than Timestamps and Times, add an extra 4 to satisfy crazy driver protocol.

Method Detail

getLPConstraintback to summary
public int getLPConstraint()
getOidback to summary
public int getOid()
getParameterback to summary
public Object getParameter(String inString, Session session) throws SQLException, RecoverableOdbcFailure

This method copied from JDBCPreparedStatement.java. The internal parameter value setter always converts the parameter to the Java type required for data transmission.

This method will not be called for binary types. Binary values are just loaded directly into the Object parameter array.

Parameters
inString:String

String

session:Session

Session

Returns:Object

Object

Exceptions
SQLException:
if either argument is not acceptable.
RecoverableOdbcFailure:
for some unsupported features
getPgTypeback to summary
public static PgType getPgType(Type hType) throws RecoverableOdbcFailure
getTypeWidthback to summary
public int getTypeWidth()
ignoredConstraintWarningback to summary
private static void ignoredConstraintWarning(Type hsqldbType)
throwErrorback to summary
pack-priv static void throwError(HsqlException e) throws SQLException
valueStringback to summary
public String valueString(Object datum)