To: Robert Treat <xzilla@users.sourceforge.net>
Cc: gearond@cvc.net, 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 
In-reply-to: <1051213745.4752.572.camel@camel> 
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>
Comments: In-reply-to Robert Treat <xzilla@users.sourceforge.net>
	message dated "24 Apr 2003 15:49:05 -0400"
Date: Thu, 24 Apr 2003 18:02:21 -0400
Message-ID: <24274.1051221741@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>

Robert Treat <xzilla@users.sourceforge.net> writes:
> 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.   

The only way I can see to do it is to make a view that has 'text'
datatypes in place of real ones, with an ON INSERT rule that invokes
your conversion functions and then inserts the result to the real table.
Dunno if that's too high on your kluge meter.

			regards, tom lane