Date: Sun, 4 Jul 2004 18:41:29 -0700 (PDT)
From: Stephan Szabo <sszabo@megazone.bigpanda.com>
To: "Dario V. Fassi" <software@sistemat.com.ar>
Cc: Kris Jurka <books@ejurka.com>, pgsql-jdbc@postgresql.org,
	pgsql-bugs@postgresql.org, pgsql-sql@postgresql.org
Subject: Re: [JDBC] Error in DatabaseMetaData.getColumns() with Views
In-Reply-To: <40E8AA9A.7020806@sistemat.com.ar>
Message-ID: <20040704183143.O56951@megazone.bigpanda.com>
References: <40E6088E.6030703@yahoo.com.ar>
	<Pine.BSO.4.56.0407030343090.19721@leary.csoft.net>
	<40E6E7AF.5020306@sistemat.com.ar> <40E6FD7F.50801@sistemat.com.ar>
	<Pine.BSO.4.56.0407041330180.26773@leary.csoft.net>
	<20040704153840.Y52747@megazone.bigpanda.com>
	<40E89282.9060306@sistemat.com.ar>
	<20040704173258.Y55353@megazone.bigpanda.com>
	<40E8AA9A.7020806@sistemat.com.ar>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII


On Sun, 4 Jul 2004, Dario V. Fassi wrote:

> Stephan, look at the samples I send in previous posts , from PgSql and Db2.

I don't see any samples apart from the original view descriptions and the
getColumns results.  I see some implication about db2 but no details.  My
guess is that the messages are more recent than the last archives update
and since I'm not on -jdbc I wouldn't have seen them.  That's pretty much
why I asked.

> I know it's a no ease task to change all that behavior , but you must
> agree that a Numeric column with the fractional part varing from row to
> row are different data types and break relational rules.

Maybe, but without seeing the example, it's hard to say.  For example,
your views from the head of what I see for this on archives, consistently
give me output with a scale of 3.

In addition, PostgreSQL provides a numeric with effectively undefined
precision and scale. This is a non-conforming definition, but means that
while the number of digits after the decimal are different, it's the same
type, numeric with undefined precision and scale.