Skip site navigation (1) Skip section navigation (2)

Re: [INTERFACES] M$-Access'97 and TIMESTAMPs

From: Byron Nikolaidis <byronn(at)insightdist(dot)com>
To: "Jose' Soares Da Silva" <sferac(at)bo(dot)nettuno(dot)it>
Cc: interfaces postgres <pgsql-interfaces(at)postgreSQL(dot)org>
Subject: Re: [INTERFACES] M$-Access'97 and TIMESTAMPs
Date: 1998-06-09 15:55:41
Message-ID: 357D5AFD.4C5207F9@insightdist.com (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-interfaces

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


In response to

pgsql-hackers by date

Next:From: Bruce MomjianDate: 1998-06-09 16:42:37
Subject: Re: [HACKERS] v6.4 - What is planned...?
Previous:From: Vadim MikheevDate: 1998-06-09 15:47:06
Subject: Re: Row-level lock

pgsql-interfaces by date

Next:From: Jose' Soares Da SilvaDate: 1998-06-09 17:25:11
Subject: Re: M$-Access'97 and TIMESTAMPs
Previous:From: Byron NikolaidisDate: 1998-06-09 15:12:13
Subject: Re: [INTERFACES] Re: M$-Access'97 and TIMESTAMPs

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group