Hi All,

Here's an idea ... a data type which implements an anonymous system generated sequence tied to the column, auto generated at table create.

The data type would be sequence4 or sequence8 (for basing on data type integer4 or integer8). The sequenceN type by definition has a default value taken from the anonymous sequence used to support it.
On creation you could specify a start number, an increment, and probably the majority of the full sequence create stuff.

alter table alter column could specify a restart number.

So we could see something like:...
create table x(
a sequence4 not null start with 100 increment by 10,
....
)...

Thoughts?

Martin Bowes

Ahhh it helps to read the manual...

What I want is almost covered by the identity column attribute you can use when creating an integer4 or integer8 column in a table.

The only fly in the ointment is that the table can only have one identity column...which seems a very artificial restraint.

Anyone have any idea why this should be limited?

Marty

From: Martin Bowes [mailto:martin.bowes (AT) ctsu (DOT) ox.ac.uk]
Sent: 21 August 2012 09:58
To: info-ingres (AT) kettleriverconsulting (DOT) com
Subject: [Info-Ingres] System generated sequences.

Hi All,

Here's an idea ... a data type which implements an anonymous system generated sequence tied to the column, auto generated at table create.

The data type would be sequence4 or sequence8 (for basing on data type integer4 or integer8). The sequenceN type by definition has a default value taken from the anonymous sequence used to support it.

On creation you could specify a start number, an increment, and probably the majority of the full sequence create stuff.

alter table alter column could specify a restart number.

So we could see something like:...
create table x(
a sequence4 not null start with 100 increment by 10,
....
)...

Thoughts?

Martin Bowes

Having more than one risks having an identity crisis.

Jeremy


--
jruffer

Well played Sir!

Marty

And leaves you open for identity theft...

~Roger Whitcomb

-----Original Message-----
From: info-ingres-bounces (AT) kettleriver...ting (DOT) com
[mailto:info-ingres-bounces (AT) kettleriverconsulting (DOT) com] On Behalf Of
Martin Bowes
Sent: Tuesday, August 21, 2012 6:53 AM
To: Ingres and related product discussion forum
Subject: Re: [Info-Ingres] System generated sequences.


Well played Sir!

Marty


_______________________________________________
Info-Ingres mailing list
Info-Ingres (AT) kettleriverconsulting (DOT) com
http://ext-cando.kettleriverconsulti...fo/info-ingres

Damn! I'm annoyed I didn't see that one coming.

Marty

And Geraint Jones just quipped 'You started an identity parade'....

The hits just keep on coming.

Marty

-----Original Message-----
From: Martin Bowes [mailto:martin.bowes (AT) ctsu (DOT) ox.ac.uk]
Sent: 22 August 2012 08:00
To: Ingres and related product discussion forum
Cc: Roger L. Whitcomb
Subject: Re: [Info-Ingres] System generated sequences.

Damn! I'm annoyed I didn't see that one coming.

Marty


_______________________________________________
Info-Ingres mailing list
Info-Ingres (AT) kettleriverconsulting (DOT) com
http://ext-cando.kettleriverconsulti...fo/info-ingres