X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 143C0D8638 for ; Fri, 26 Aug 2005 14:04:12 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 38231-08 for ; Fri, 26 Aug 2005 17:04:08 +0000 (GMT) Received: from floppy.pyrenet.fr (floppy.pyrenet.fr [194.116.145.2]) by svr1.postgresql.org (Postfix) with ESMTP id 999D1D8640 for ; Fri, 26 Aug 2005 14:04:07 -0300 (ADT) Received: by floppy.pyrenet.fr (Postfix, from userid 106) id 38C2631F52; Fri, 26 Aug 2005 19:16:48 +0200 (MET DST) From: Chris Browne X-Newsgroups: pgsql.sql Subject: Re: Tidying values on variable instantiation Date: Fri, 26 Aug 2005 12:34:10 -0400 Organization: cbbrowne Computing Inc Lines: 16 Message-ID: <60r7cglksd.fsf@dba2.int.libertyrms.com> References: <200508261304.10542.dave.bath@unix.net> Mime-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 X-Complaints-To: usenet@news.hub.org User-Agent: Gnus/5.1007 (Gnus v5.10.7) XEmacs/21.4.17 (Jumbo Shrimp, linux) Cancel-Lock: sha1:J9OKR1+s9lWfhPgLG1vlG+RVAjc= To: pgsql-sql@postgresql.org X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.106 required=5 tests=[AWL=0.106] X-Spam-Level: X-Archive-Number: 200508/249 X-Sequence-Number: 22477 gpatnude@hotmail.com ("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