Re: Using a postgres table to maintain unique id?

From: Forest Wilkinson <fspam(at)home(dot)com>
To: Dr Frog <drfrog(at)smartt(dot)com>
Cc: <pgsql-sql(at)postgresql(dot)org>
Subject: Re: Using a postgres table to maintain unique id?
Date: 2000-11-13 18:53:58
Message-ID: 22e01tsb44dci6ath4tauffij41g2uona9@4ax.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On 13 Nov 2000 10:30:55 PST, Dr Frog wrote:

>create sequnece seq_name ;
>
>there are additional options
>start sql and type

What are the "SQL" and "TYPE" options? I don't see reference to them in
the docs.

Can I use the TYPE option to create a sequence that's based in int8 (64
bit integer) instead of int4? That's exactly what I've been wanting!
What version of postgres supports this?

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Steve Wampler 2000-11-13 19:36:35 Re: Using a postgres table to maintain unique id?
Previous Message Steve Wampler 2000-11-13 17:44:21 Re: Using a postgres table to maintain unique id?