Message-ID: <3EA84A9C.1040901@cvc.net>
Date: Thu, 24 Apr 2003 13:35:40 -0700
From: Dennis Gearon <gearond@cvc.net>
Reply-To: gearond@cvc.net
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US;
	rv:1.3b) Gecko/20030210
MIME-Version: 1.0
To: Robert Treat <xzilla@users.sourceforge.net>
Cc: Josh Berkus <josh@agliodbs.com>,
	"pgsql-general@postgresql.org" <pgsql-general@postgresql.org>,
	pgsql-sql@postgresql.org
Subject: Re: [SQL] rewriting values with before trigger
References: <1051201544.4753.522.camel@camel>
	<200304240939.54070.josh@agliodbs.com>	<1051209495.7747.544.camel@camel>
	<3EA836AF.8060704@cvc.net>	<1051212144.4752.558.camel@camel>
	<3EA83C95.8070404@cvc.net> <1051213745.4752.572.camel@camel>
In-Reply-To: <1051213745.4752.572.camel@camel>
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit

I **LIKE** your kind of thinking :-)

Don't mess up the data.

Don't mess up the schema.

It hurts or causes LOTS of labor later on.

Robert Treat wrote:
> On Thu, 2003-04-24 at 15:35, Dennis Gearon wrote:
> 
>>Well,
>>	does ''::INT do anything valuable?
> 
> 
> 	not in 7.3+, and given my original problem involves timestamps, not in
> 7.2 either. 
> 
> 
>>	change column to a string, convert to INTS on the way out, STRINGS on the way in?
>>	use an external language to make transitions.
>>
> 
> 
> yeah, I've thought of some other crazy ways to get around this, but the
> problem is due to a bug in the application side. I was hoping I could
> write a quick hack (like adding a rule/trigger) to get around this until
> the app was fixed, but I'm not going to make my side a kludge when it
> isn't one now.   
> 
> 
> Robert Treat
> 
> 
>