Re: new serial type - Mailing list pgsql-sql

From Kaare Rasmussen
Subject Re: new serial type
Date
Msg-id 01011312373400.24341@bering
Whole thread Raw
In response to new serial type  (Rolf Johansson <rojo@nocrew.org>)
List pgsql-sql
Den l�rdag 13. januar 2001 11:42 skrev Rolf Johansson:
> Is there some function to change the serial type to, instead of reading
> a next-value, read the maxium value in a column and then add x? If, for

You can use setval(sequence, number) and MAX(number) in combination.

-- 
Kaare Rasmussen            --Linux, spil,--        Tlf:        3816 2582
Kaki Data                tshirts, merchandize      Fax:        3816 2501
Howitzvej 75               �ben 14.00-18.00        Email: kar@webline.dk
2000 Frederiksberg        L�rdag 11.00-17.00       Web:      www.suse.dk


pgsql-sql by date:

Previous
From: Rolf Johansson
Date:
Subject: new serial type
Next
From: Jan Wieck
Date:
Subject: Re: pl/pgsql Limits