X-Original-To: pgsql-general@postgresql.org
Received: from spampd.localdomain (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP
	id BFF76475F16; Thu, 24 Apr 2003 15:49:08 -0400 (EDT)
Received: from localhost.localdomain (unknown [65.217.53.66])
	by postgresql.org (Postfix) with ESMTP
	id 17EBA475E9D; Thu, 24 Apr 2003 15:49:08 -0400 (EDT)
Received: from thorn.mmrd.com (thorn.mmrd.com [172.25.10.100])
	by localhost.localdomain (8.12.8/8.12.8) with ESMTP id h3OKV7F0027037;
	Thu, 24 Apr 2003 16:31:07 -0400
Received: from gnvex001.mmrd.com (gnvex001.mmrd.com [192.168.3.55])
	by thorn.mmrd.com (8.11.6/8.11.6) with ESMTP id h3OJn5x11289;
	Thu, 24 Apr 2003 15:49:05 -0400
Received: from camel.mmrd.com ([172.25.5.213]) by gnvex001.mmrd.com with SMTP
	(Microsoft Exchange Internet Mail Service Version 5.5.2653.13)
	id 2YCPW294; Thu, 24 Apr 2003 15:49:03 -0400
Subject: Re: [SQL] rewriting values with before trigger
From: Robert Treat <xzilla@users.sourceforge.net>
To: gearond@cvc.net
Cc: Josh Berkus <josh@agliodbs.com>,
	"pgsql-general@postgresql.org" <pgsql-general@postgresql.org>,
	pgsql-sql@postgresql.org
In-Reply-To: <3EA83C95.8070404@cvc.net>
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>
Content-Type: text/plain
Content-Transfer-Encoding: 7bit
X-Mailer: Ximian Evolution 1.0.8 
Date: 24 Apr 2003 15:49:05 -0400
Message-Id: <1051213745.4752.572.camel@camel>
Mime-Version: 1.0
X-Spam-Status: No, hits=-35.6 required=5.0
	tests=BAYES_01,EMAIL_ATTRIBUTION,IN_REP_TO,REFERENCES,
	REPLY_WITH_QUOTES,USER_AGENT_XIMIAN autolearn=ham	version=2.50
X-Spam-Level: 
X-Spam-Checker-Version: SpamAssassin 2.50 (1.173-2003-02-20-exp)
X-Archive-Number: 200304/1268
X-Sequence-Number: 41333

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