>
>
> 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