Re: ResultSetMetaData.getColumnDisplaySize returns 2147483647 ?

From: Hannu Krosing <hannu(at)2ndQuadrant(dot)com>
To: DGPickett <DGPickett(at)aol(dot)com>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: ResultSetMetaData.getColumnDisplaySize returns 2147483647 ?
Date: 2009-03-02 22:17:28
Message-ID: 1236032248.7132.5.camel@huvostro
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

On Fri, 2009-02-27 at 09:41 -0800, DGPickett wrote:

> Somehow, doing what the real money RDBMS do, the de-facto standard,

Could you describe, what do they do, especially for cases of really
unknown sizes ?

One solution would be to fetch all data into a buffer and actually
measure the longest field size.

> is
> hard for postgres dudes, or they have more important concerns. It
> makes the product seem shabby by comparison. Usually, that is enough
> to motivate frantic coding, to make open source appear just as good.

You are most welcome to "code frantically" :)

PostgreSQL "dudes" in general are not in business of appearing just as
good. Rather we are trying to produce the most advanced database
available, at least for values of "most advanced" that matter to us.

--
Hannu Krosing http://www.2ndQuadrant.com
PostgreSQL Scalability and Availability
Services, Consulting and Training

In response to

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Guy Rouillier 2009-03-02 23:53:23 Re: Cannot create JDBC driver of class '' for connect URL 'null'
Previous Message DGPickett 2009-03-02 16:25:53 Re: ResultSetMetaData.getColumnDisplaySize returns 2147483647 ?