On Sun, 04 Aug 2002 13:07:29 +0900
I <rk73(at)sea(dot)plala(dot)or(dot)jp> wrote:
I'm sorry, the outputs of the results had mistakes in the previous mail.
> -- outputs of the results of initial INSERT/UPDATE
> SELECT * FROM tbl;
> a | b
> ----+---
> 1 | d
> 4 | r
> 10 | g
> 2 | p
> (4 rows)
a | b
----+---
1 | d
4 | r
10 | i
2 | p
(4 rows)
> -- outputs of the result after re-createing a primary key.
> SELECT * FROM tbl;
> a | b
> ---+---
> 1 | d
> 2 | p
> 3 | r
> 4 | g
> (4 rows)
a | b
---+---
1 | d
2 | p
3 | r
4 | i
(4 rows)
Regards,
Masaru Sugawara