From: Jasmin Dizdarevic <jasmin.dizdarevic@gmail.com>
To: Axe <info@axier.se>
To: pgsql-sql@postgresql.org
Subject: Re: Tweak sql result set... ?
Date: Thu, 30 Jul 2009 09:53:01 +0200
Message-ID: <a0eee4d40907300053x1d19e1d8n52ece03dc9490dbb@mail.gmail.com> (raw)
In-Reply-To: <b0fab1d4-841f-4df9-b201-1cc7918f12f6@h11g2000yqb.googlegroups.com>
References: <2981e447-3f11-4002-92fb-06a6af39762e@c29g2000yqd.googlegroups.com>
<m3k51s72vl.fsf@passepartout.tim-landscheidt.de>
<b0fab1d4-841f-4df9-b201-1cc7918f12f6@h11g2000yqb.googlegroups.com>
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 <info@axier.se>
>
> > > Any ideas on how to achieve this? I would like to let the original sql
> > > code stay original. I can prepare postgres before executing the sql if
> > > this makes it easier to acheive the goal
> >
> > Have a look at CREATE RULE.
> >
> > Tim
> >
> Ok, you mean I could create a rule for the table, then I let the
> script go into my "black box",
> do the original selects, but get a manipulated result set back, then I
> drop the rule so
> that the blackbox of scripts can get the not manipulated result set
> back?
>
> I need to sometimes get the result "<div>output from query</div>" and
> sometimes not
> and it would be awesomw to get it with the same query, but maybe by
> setting
> a rule or similar. Best from performance view would be to make
> something
> more permanent. Is it possible to activate/deactivate a rule?
>
> Axe
>
> --
> Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-sql
>
--
Mit freundlichen Grüßen
Dizdarevic Jasmin
Sonnenbergstr. 3
6714 Nüziders, AUT
jasmin.dizdarevic@gmail.com
+43 664 411 79 29
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: jasmin.dizdarevic@gmail.com, info@axier.se
Subject: Re: Tweak sql result set... ?
In-Reply-To: <a0eee4d40907300053x1d19e1d8n52ece03dc9490dbb@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox