Re: new serial type

From: Kaare Rasmussen <kar(at)webline(dot)dk>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: new serial type
Date: 2001-01-13 11:37:34
Message-ID: 01011312373400.24341@bering
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Den lrdag 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(at)webline(dot)dk
2000 Frederiksberg Lrdag 11.00-17.00 Web: www.suse.dk

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Jan Wieck 2001-01-13 14:04:59 Re: pl/pgsql Limits
Previous Message Rolf Johansson 2001-01-13 10:42:56 new serial type