Postgres Pro
Downloads
Home   >   mailing lists

SQL TYPE MAP such as SQL_CHAR, SQL_NUMERIC , etc - Mailing list pgsql-general

From Emi Lu
Subject SQL TYPE MAP such as SQL_CHAR, SQL_NUMERIC , etc
Date
Msg-id 43FDD577.2030203@encs.concordia.ca
Whole thread Raw
Responses Re: SQL TYPE MAP such as SQL_CHAR, SQL_NUMERIC , etc  (Emi Lu <emilu@encs.concordia.ca>)
List pgsql-general
Tree view 
Hello,

May I know where I can find some online documents about mapping the
integer values to the following SQL types please?

For example, if I have value 1 , so that I know 1 is mapped to SQL_CHAR;
if I have value 3, so that I know 3 is mapped to SQL_NUMERIC.

Thanks a lot,
Emi



        Data Types

  The following data types are supported:

  SQL_CHAR

  SQL_VARCHAR

  SQL_LONGVARCHAR

  SQL_NUMERIC

  SQL_DECIMAL

  SQL_SMALLINT

  SQL_INTEGER

  SQL_REAL

  SQL_FLOAT

  SQL_DOUBLE

  SQL_BIT

  SQL_TINYINT

  SQL_BIGINT

  SQL_BINARY

  SQL_VARBINARY

  SQL_LONGVARBINARY

  SQL_TYPE_DATE

  SQL_TYPE_TIME

  SQL_TYPE_TIMESTAMP

  SQL_INTERVALS (all types)

pgsql-general by date:

Previous
From: Michael Fuhr
Date:
Subject: Re: ExclusiveLock without a relation in pg_locks
Next
From: Vivek Khera
Date:
Subject: Re: Is there a way to check which indexes are being used