SQL TYPE MAP such as SQL_CHAR, SQL_NUMERIC , etc

From: Emi Lu <emilu(at)encs(dot)concordia(dot)ca>
To: pgsql-general(at)postgresql(dot)org
Subject: SQL TYPE MAP such as SQL_CHAR, SQL_NUMERIC , etc
Date: 2006-02-23 15:32:07
Message-ID: 43FDD577.2030203@encs.concordia.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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)

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Vivek Khera 2006-02-23 15:44:38 Re: Is there a way to check which indexes are being used
Previous Message Michael Fuhr 2006-02-23 15:05:29 Re: ExclusiveLock without a relation in pg_locks