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

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 (view raw, whole thread or download thread mbox)
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
PostgreSQL Scalability and Availability 
   Services, Consulting and Training

In response to


pgsql-jdbc by date

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

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