Re: Selecting a constant question
Joshua D. Drake <jd@commandprompt.com>
From: "Joshua D. Drake" <jd@commandprompt.com>
To: Hannu Krosing <hannu@skype.net>
Cc: Larry McGhaw <lmcghaw@connx.com>, Martijn van Oosterhout <kleptog@svana.org>, Andrew Dunstan <andrew@dunslane.net>, Tom Lane <tgl@sss.pgh.pa.us>, Alvaro Herrera <alvherre@commandprompt.com>, Dann Corbit <DCorbit@connx.com>, Gregory Stark <stark@enterprisedb.com>, pgsql-hackers@postgresql.org
Date: 2007-06-13T04:55:07Z
Lists: pgsql-hackers
Hannu Krosing wrote:
> Ühel kenal päeval, T, 2007-06-12 kell 13:40, kirjutas Larry McGhaw:
>> For what its worth .. Your statement about why we are the first people
>> to mention this problem really got me thinking. Anyone who would
>> attempt to write an ODBC driver for Postgres would run into the exact
>> same issue. So I installed the official Postgres ODBC driver, and ran
>> the identical query and here are my results:
>>
>> I probably should have looked at this first .... There is a whole
>> Postgres ODBC dialog dedicated to the very subject of this thread:
>> Handling of "unknown" data sizes. The pgodbc driver is configured to
>> treat unknowns as varchar(255) by default,
>> As shown by my example below. This can be configured up or down as
>> desired.
>
> BTW, what is the reason you are writing your own ODBC driver ?
They aren't I don't think. I think they are using the ODBC driver as an
example.
Joshua D. Drake
>
> What problems in the official one are you trying to solve ?
>
> --------------
> Hannu
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faq
>
--
=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive PostgreSQL solutions since 1997
http://www.commandprompt.com/
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/