Re: why not type casting by default in prepared statements?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Harald Krake <harald(at)krake(dot)de>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: why not type casting by default in prepared statements?
Date: 2002-11-16 16:20:14
Message-ID: 18505.1037463614@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Harald Krake <harald(at)krake(dot)de> writes:
> But now I'm wondering whether there are any good reasons
> not to type cast by default?

This has been suggested, and rejected, repeatedly. It's not a good
idea to apply a driver-side band-aid to mask a server-side problem;
especially not when the driver does not have adequate information to
fix the problem properly. (In other words, any driver-side solution
will fix some queries and break others.)

There will be a real solution in the backend someday soon, perhaps 7.4.

regards, tom lane

In response to

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Harald Krake 2002-11-16 18:23:01 Re: why not type casting by default in prepared statements?
Previous Message Harald Krake 2002-11-16 14:51:40 why not type casting by default in prepared statements?