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