Re: to add table with primary key

From: Frank van Bortel <>
Date: Fri, 07 Mar 2008 19:54:27 +0100
Message-ID: <2272b$47d18f64$524b5c40$>

Michael Austin wrote:
> codadilupo wrote:

>> shakespeare wrote:
>>> I often wonder why people use sequences and want to keep control of
>>> the values.
>> Me too. For example, some of my clients don't want sequence gaps or want
>> sequences to start again with 1 at the beginning of each year.

> Obviously this can NOT be used as a PK.

Of course it can when the year is added - that is the other part of the request: change the control record from 2007 to 2008.



Frank van Bortel

Top-posting in UseNet newsgroups is one way to shut me up
Received on Fri Mar 07 2008 - 12:54:27 CST

Original text of this message