Re: SQL TYPE MAP such as SQL_CHAR, SQL_NUMERIC , etc

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

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)

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Karl Wright 2006-02-23 20:49:09 How do I prevent binding to TCP/IP port outside of localhost?
Previous Message Kevin Murphy 2006-02-23 20:43:17 How I changed the encoding of template1 after the fact