Re: Wrong column size using MIN/MAX without return result

From: Clemens Ladisch <clemens(at)ladisch(dot)de>
To: pgsql-odbc(at)lists(dot)postgresql(dot)org
Subject: Re: Wrong column size using MIN/MAX without return result
Date: 2018-09-25 06:43:00
Message-ID: f1ac4d09-bf17-3002-66d8-a85278c0632c@ladisch.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

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

In response to

Browse pgsql-odbc by date

  From Date Subject
Next Message 狐狸的面包雨 2018-09-25 09:30:22 psqlodbc && nested transaction
Previous Message Inoue, Hiroshi 2018-09-25 03:12:30 Re: Wrong column size using MIN/MAX without return result