Topic: Invoice numbers

[clay1]

Anyone have any tutorials or directions on creating invoice numbers?

I have a table called invoices with a column named invoicenumber which is set to a serial

I want to be able to assign a new invoice the next number in the sequence.

[artacus]

Easiest way would be to use the keyword DEFAULT for the invoice number.

INSERT INTO invoices (invoicenumber, invoice_time, customer_id)
VALUES (DEFAULT, current_timestamp, 222);

Otherwise you can use nextval('invoice_seq') where invoice_seq is the name of your sequence.