Re: [HACKERS] Re: [QUESTIONS] Business cases

 > 
> 
> Moved to pgsql-hackers@postgresql.org, where it should have been moved
> *ages* ago
> 
> Connected to:
> Oracle7 Server Release 7.3.3.0.0 - Production Release
> With the distributed, replication and parallel query options
> PL/SQL Release 2.3.3.0.0 - Production
> 
> SQL> create table one ( a integer primary key not null );
> 
> Table created.
> 
> SQL> insert into one values (2);
> 
> 1 row created.
> 
> SQL> insert into one values (3);
> 
> 1 row created.
> 
> SQL> insert into one values (1);
> 
> 1 row created.
> 
> SQL> select * from one;
> 
>          A
> ----------
>          2
>          3
>          1
> 
> SQL> update one set a=a+1;
> 
> 3 rows updated.
> 
> SQL> select * from one;
> 
>          A
> ----------
>          3
>          4
>          2
> 

Man, how do you implement that behavior?  No wonder MySQL fails on it
too.


-- 
Bruce Momjian
maillist@candle.pha.pa.us