Re: sequence data type

From: Gavin Flower <GavinFlower(at)archidevsys(dot)co(dot)nz>
To: Vik Fearing <vik(at)2ndquadrant(dot)fr>, Peter Eisentraut <peter(dot)eisentraut(at)2ndquadrant(dot)com>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: sequence data type
Date: 2016-09-03 23:01:38
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers

On 04/09/16 06:41, Vik Fearing wrote:
> On 08/31/2016 06:22 AM, Peter Eisentraut wrote:
>> Here is a patch that adds the notion of a data type to a sequence. So
>> it might be CREATE SEQUENCE foo AS integer. The types are restricted to
>> int{2,4,8} as now.
> This patch does not apply cleanly to current master (=600dc4c).

Must admit I first thought of: "2, 4, 8, who do we appreciate!"


Would a possibly future expansion be to include numeric?

Of hand, I can't see any value for using other than integers of 2, 4, &
8 bytes (not a criticism! - may simply be a failure of imagination on my

I am curious as to the use cases for other possibilities.


In response to


Browse pgsql-hackers by date

  From Date Subject
Next Message Michael Paquier 2016-09-03 23:05:25 Re: LSN as a recovery target
Previous Message Vik Fearing 2016-09-03 20:57:08 Long options for pg_ctl waiting