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

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search archives
  Advanced Search

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: Sat, 16 Nov 2002 11:20:14 -0500
  • Message-id: <18505.1037463614@sss.pgh.pa.us> <text/plain>

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



Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group