Re: to add table with primary key

From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Fri, 07 Mar 2008 19:54:27 +0100
Message-ID: <2272b$47d18f64$524b5c40$19610@cache6.tilbu1.nb.home.nl>

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.

BTDT

-- 

Regards,
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

This message: [ Message body ]
Next message: Frank van Bortel: "Re: trace every SQL statement of a specific user"
Previous message: Frank van Bortel: "Re: Oracle sequence returning duplicate key for a given key name"
In reply to: Michael Austin: "Re: to add table with primary key"
Next in thread: codadilupo: "Re: to add table with primary key"
Reply: codadilupo: "Re: to add table with primary key"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message