Postgres Pro
Downloads
Home   >   mailing lists

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

From Emi Lu
Subject Re: SQL TYPE MAP such as SQL_CHAR, SQL_NUMERIC , etc
Date
Msg-id 43FE1EFF.9040505@encs.concordia.ca
Whole thread Raw
In response to SQL TYPE MAP such as SQL_CHAR, SQL_NUMERIC , etc  (Emi Lu <emilu@encs.concordia.ca>)
Responses Re: SQL TYPE MAP such as SQL_CHAR, SQL_NUMERIC , etc  (Ragnar <gnari@hive.is>)
List pgsql-general
Tree view 
I am waiting for your clues.

- Emi



> 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.
>
>
>        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: Kevin Murphy
Date:
Subject: How I changed the encoding of template1 after the fact
Next
From: "Chandra Sekhar Surapaneni"
Date:
Subject: Re: subtracting minutes from date