Postgres Pro
Downloads
Home   >   mailing lists

Re: Invoice number - Mailing list pgsql-sql

From Volker Paul
Subject Re: Invoice number
Date
Msg-id 3A41E325.C8E5D7EF@dohle.com
Whole thread Raw
In response to Invoice number  (Kaare Rasmussen <kar@webline.dk>)
List pgsql-sql
Tree view 
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

pgsql-sql by date:

Previous
From: Volker Paul
Date:
Subject: Re: Create table doesn't work in plpgsql
Next
From: Mike Castle
Date:
Subject: Re: Invoice number