Postgres Pro
Downloads
Home   >   mailing lists

Re: Wrong column size using MIN/MAX without return result - Mailing list pgsql-odbc

From Clemens Ladisch
Subject Re: Wrong column size using MIN/MAX without return result
Date
Msg-id f1ac4d09-bf17-3002-66d8-a85278c0632c@ladisch.de
Whole thread Raw
In response to Wrong column size using MIN/MAX without return result  (Fabrízio de Royes Mello <fabriziomello@gmail.com>)
List pgsql-odbc
Tree view 
Fabrízio de Royes Mello wrote:
> When we use MIN/MAX functions in a query returning CHAR without results, the column size is wrong.

The column size is the property of a column, so the return value of
a function does not really have this property.

> There are some config to fix this weird behaviour?

Have a look at "Unknown Sizes", "Text as LongVarChar", "Max Varchar",
and "Max LongVarChar": <https://odbc.postgresql.org/docs/config.html>


Regards,
Clemens

pgsql-odbc by date:

Previous
From: "Inoue, Hiroshi"
Date:
Subject: Re: Wrong column size using MIN/MAX without return result
Next
From: 狐狸的面包雨
Date:
Subject: psqlodbc && nested transaction