| 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: | Whole Thread | Raw Message | 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... ? |