From: | Axe <info(at)axier(dot)se> |
---|---|
To: | pgsql-sql(at)postgresql(dot)org |
Subject: | Re: Tweak sql result set... ? |
Date: | 2009-07-29 06:35:17 |
Message-ID: | b0fab1d4-841f-4df9-b201-1cc7918f12f6@h11g2000yqb.googlegroups.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | Gau, Hans-Jürgen | 2009-07-29 09:48:23 | WG: sql-porting-problem oracle to postgresql with UPDATE/IS NOT NULL |
Previous Message | Tim Landscheidt | 2009-07-29 00:24:14 | Re: Tweak sql result set... ? |