[EMAIL PROTECTED] ("Greg Patnude") writes:
> Data validation and purification should be performed at the
> application layer -- you should format your data appropriately
> BEFORE trying any INSERT/UPDATE operations.It seems to me that one might create some stored functions that can do some validation/purification which, by virtue of residing in the database, have the ability to efficiently access other data in order to do data-based validation. I know I have found that to be a useful approach... -- "cbbrowne","@","ntlug.org" http://cbbrowne.com/info/linuxdistributions.html "The day Microsoft makes something that doesn't suck is probably the day they start making vacuum cleaners" - Ernst Jan Plugge ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
