| 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 |
| Message-ID: | 1eb60c67-4d59-6e3f-e5a3-afe401c52b98@archidevsys.co.nz |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| 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!"
MORE SERIOUSLY:
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
part).
I am curious as to the use cases for other possibilities.
Cheers,
Gavin
| 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 |