Re: RULE vs. SEQUENCE - Mailing list pgsql-hackers

From Hannu Krosing
Subject Re: RULE vs. SEQUENCE
Date
Msg-id 39B380FA.F2903F94@tm.ee
Whole thread Raw
In response to Re: RULE vs. SEQUENCE  (Karel Zak <zakkr@zf.jcu.cz>)
Responses Re: RULE vs. SEQUENCE
List pgsql-hackers
Karel Zak wrote:
> 
> On Mon, 4 Sep 2000, Jan Wieck wrote:
> 
> > >  I have a question... why RULE call nexval() and data in RULE statement are
> > > differend than data in original stmt.
> >
...
> 
>  But executor can knows that somethig was already executed, we can mark
> some already executed expressions in rewriter and not execute it again in
> final executor... like:
...
> 
>  IMHO this is a good point for 7.2 ...

But if instead of nextval() you had random(), would you still want to execute
it 
only once ? And how should postgres know ?

----------
Hannu


pgsql-hackers by date:

Previous
From: t-ishii@sra.co.jp
Date:
Subject: Re: Re: [PATCHES] Important 7.0.* fix to ensure buffers are released
Next
From: Karel Zak
Date:
Subject: Re: RULE vs. SEQUENCE