From: Byron Nikolaidis <byronn@insightdist.com>
To: Jose' Soares Da Silva <sferac@bo.nettuno.it>
Cc: interfaces postgres <pgsql-interfaces@postgreSQL.org>
Subject: Re: [INTERFACES] M$-Access'97 and TIMESTAMPs
Date: Tue, 09 Jun 1998 11:55:41 -0400
Message-ID: <357D5AFD.4C5207F9@insightdist.com> (raw)
References: <Pine.LNX.3.96.980609143546.2496A-100000@proxy.bazzanese.com>
Jose' Soares Da Silva wrote:
> Also the following types are recognized as text:
> int28
> oid8
> oidint2
> oidint4
>
Just a little history here...any data type that is not directly supported by the
odbc driver will get mapped to SQL_VARCHAR or SQL_LONGVARCHAR, depending on
driver 'data type options'. That allows you to view it and possibly update it,
if there is an appropriate operator. This is great compared to what the driver
used to do in the old days with unsupported types (i.e., crash with no
descriptive error message)!
For int28 and oid8, there is no SQL data type that maps. Text is the only way to
display it that I know of.
oidint2 and oidint4 are just integers I guess, and probably could be mapped to
SQL_SMALLINT and SQL_INTEGER, respectively.
Byron
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: byronn@insightdist.com, sferac@bo.nettuno.it
Subject: Re: [INTERFACES] M$-Access'97 and TIMESTAMPs
In-Reply-To: <357D5AFD.4C5207F9@insightdist.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox