Re: Tweak sql result set... ? - Mailing list pgsql-sql

From Axe
Subject Re: Tweak sql result set... ?
Date
Msg-id b0fab1d4-841f-4df9-b201-1cc7918f12f6@h11g2000yqb.googlegroups.com
Whole thread Raw
In response to Tweak sql result set... ?  (Axe <info@axier.se>)
Responses Re: Tweak sql result set... ?
List pgsql-sql
> > 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


pgsql-sql by date:

Previous
From: "Gau, Hans-Jürgen"
Date:
Subject: WG: WG: sql-porting-problem oracle to postgresql with UPDAT E/IS NOT NULL
Next
From: Kjell Rune Skaaraas
Date:
Subject: Foreign keys and fixed values...