There is only one condition under which this would be useful.
Select x into var from inventory where y=const;
some more DMLs.
some select into var2;
if (condition based on var2)
use the var;
here i have to fire the first select query all the 100% of the time. Say if
i have a feature to time travel within a transaction, i need to fire that
select query on the probability of the condition based on var2 getting true.
After that implementation
store command id and increment it into cid;
some select into var2
if(condition based on var2)
select into :var as of cid;
I know this is a small use-case. But if you think about it, the
implementation is very easy. It wouldn't take much time to implement it.
On 10/31/07, Heikki Linnakangas <heikki(at)enterprisedb(dot)com> wrote:
> Gokulakannan Somasundaram wrote:
> > a) Is there a proposal in place for going back in time within a
> Within a transaction? No, can't remember one. Doesn't sound very useful.
> Heikki Linnakangas
> EnterpriseDB http://www.enterprisedb.com
Allied Solution Groups.
In response to
pgsql-hackers by date
|Next:||From: Sheikh Amjad||Date: 2007-10-31 12:21:35|
|Subject: Postgresql 8.3 beta crash|
|Previous:||From: Gokulakannan Somasundaram||Date: 2007-10-31 11:38:49|
|Subject: Re: Clarification on a Time travel feature|