Re: Serials: removing the holes? (consecutive) - Mailing list pgsql-general

From Masaru Sugawara
Subject Re: Serials: removing the holes? (consecutive)
Date
Msg-id 20020804132304.1EA5.RK73@sea.plala.or.jp
Whole thread Raw
In response to Re: Serials: removing the holes? (consecutive)  (Masaru Sugawara <rk73@sea.plala.or.jp>)
List pgsql-general
On Sun, 04 Aug 2002 13:07:29 +0900
I  <rk73@sea.plala.or.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



pgsql-general by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Data Corruption
Next
From: Alvaro Herrera
Date:
Subject: Re: Searching accented words