Re: a dumb question regarding RULES

From: Rafal Pietrak <rafal(at)zorro(dot)isa-geek(dot)com>
To: depesz(at)depesz(dot)com
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: a dumb question regarding RULES
Date: 2011-10-10 21:02:04
Message-ID: 1318280524.12208.21.camel@localhost.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mon, 2011-10-10 at 16:48 +0200, hubert depesz lubaczewski wrote:
> On Mon, Oct 10, 2011 at 04:06:34PM +0200, Rafal Pietrak wrote:
> > Hi all,
>
> first of all - why did you send this mail as reply to some 2-weeks old
> thread, instead of just start of new thread?

Sorry for that. Old habits... always forget that.

>
> > Can someone give a little explenation here ... or point me to "for
> > dummies" documentation? (yes, I've been though postgres docs, to no
> > avail).
>
> perhaps this will help:
>
> http://www.depesz.com/index.php/2010/06/15/to-rule-or-not-to-rule-that-is-the-question/
>

Hmmm. not really. Yet, more puzzles are there, so may be they'll guide
me to the answer, eventualy.

One thing I've spotted there, is that earlier I've naively assumed, that
when I define a RULE INSTEAD, the original query is "discarded" on the
final rewritten query. The example found at your link shows that it
isn't ... which is *extremally* strange, but somehow explains what I get
in my set of rules "supposedly" exclusive.

... or may be this "theory" is also wrong :(

Anyway, thenx for the link.

-R

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Rich Shepard 2011-10-10 22:17:23 SELECT statement not working as intended
Previous Message Bosco Rama 2011-10-10 20:10:33 Re: select vs cursor/fetch speed disparity