Re: Invoice number

From: Volker Paul <vpaul(at)dohle(dot)com>
To: Kaare Rasmussen <kar(at)webline(dot)dk>
Cc: PostgreSQL-SQL <pgsql-sql(at)postgresql(dot)org>
Subject: Re: Invoice number
Date: 2000-12-21 11:01:57
Message-ID: 3A41E325.C8E5D7EF@dohle.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi,

> I'm wondering how people creates guaranteed sequential numbers - in my case
> for invoice numbers.

See the PostgreSQL book p. 85 and 250, and the online doc about serials:
CREATE TABLE person ( id SERIAL, name TEXT );

Volker Paul

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Josh Berkus 2000-12-21 15:49:46 Re: Invoice number
Previous Message Volker Paul 2000-12-21 10:51:38 Re: Create table doesn't work in plpgsql