Re: operator varchar = integer - Mailing list pgsql-general

From David Fetter
Subject Re: operator varchar = integer
Date
Msg-id 20080505143330.GG5791@fetter.org
Whole thread Raw
In response to operator varchar = integer  (Daniel Schuchardt <daniel_schuchardt@web.de>)
Responses Re: operator varchar = integer  (Daniel Schuchardt <daniel_schuchardt@web.de>)
List pgsql-general
On Mon, May 05, 2008 at 11:18:37AM +0200, Daniel Schuchardt wrote:
> Hey Group,
>
> i know what all will say but i need to recreate the = operator for
> datatypes varchar and integer in PostgreSQL 8.3.
>
> Our Software Project has Millions of Lines and so it would be
> difficult to check all queries and Datatypes.

That technical debt is a risk to your whole project, and you need to
dedicate resources to paying it down.

<http://en.wikipedia.org/wiki/Technical_debt>

There are ways to get those automated casts, but they will only make
your situation worse in the long run.

Cheers,
David.
--
David Fetter <david@fetter.org> http://fetter.org/
Phone: +1 415 235 3778  AIM: dfetter666  Yahoo!: dfetter
Skype: davidfetter      XMPP: david.fetter@gmail.com

Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Archive_command
Next
From: "Scott Marlowe"
Date:
Subject: Re: COPY Performance