Received: from localhost (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id 0D9196356C3 for ; Thu, 30 Jul 2009 10:48:19 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024) with ESMTP id 81753-03 for ; Thu, 30 Jul 2009 13:47:59 +0000 (UTC) Received: from news.hub.org (news.hub.org [200.46.204.72]) by mail.postgresql.org (Postfix) with ESMTP id 15B13634A71 for ; Thu, 30 Jul 2009 10:48:08 -0300 (ADT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by news.hub.org (8.14.3/8.14.3) with ESMTP id n6UDm1Lb079149 for ; Thu, 30 Jul 2009 10:48:01 -0300 (ADT) (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.14.3/8.14.3/Submit) id n6UDVJCQ052513 for pgsql-sql@postgresql.org; Thu, 30 Jul 2009 10:31:19 -0300 (ADT) (envelope-from news) From: Axe X-Newsgroups: pgsql.sql Subject: Re: Tweak sql result set... ? Date: Thu, 30 Jul 2009 06:31:24 -0700 (PDT) Organization: http://groups.google.com Lines: 23 Message-ID: References: a0eee4d40907300053x1d19e1d8n52ece03dc9490dbb@mail.gmail.com Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Complaints-To: groups-abuse@google.com Complaints-To: groups-abuse@google.com Injection-Info: 26g2000yqk.googlegroups.com; posting-host=85.225.230.26; posting-account=YuhnMQoAAAAs68d0yAtMkm1jXJH7LV0o User-Agent: G2/1.0 X-HTTP-UserAgent: Mozilla/5.0 (Windows; U; Windows NT 6.0; en-US) AppleWebKit/530.5 (KHTML, like Gecko) Chrome/2.0.172.37 Safari/530.5, gzip(gfe), gzip(gfe) To: pgsql-sql@postgresql.org X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=-10 required=5 tests=none X-Spam-Level: X-Archive-Number: 200908/2 X-Sequence-Number: 32911 > i think jasen is thinking of manipulating the result set in your programming > enviroment not in the database. > btw from the point of "clean programming" it's a bad idea to integrate > html-elements directly into your database quereis. you're mixing data layer > and design layer. > > what do you mean with sometimes? > 2009/7/29 Axe > I am aware of this "clean programming" and this is a part of why I am trying to keep my blackbox of script intact since I want to keep a good standard in those scripts. Why I need it "sometimes" is beacuse I want to use the set of production scripts for test purposes. "Intact" and when I am doing some tests, I would benefit from manipulating the result set I am getting out from postgres for testing purposes by just prepend my test-workbench on top of the production script. / Axe