Re: Auto increment/sequence on multiple columns?

From: Thomas F(dot)O'Connell <tfo(at)sitening(dot)com>
To: nboutelier(at)hotmail(dot)com (Nick)
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Auto increment/sequence on multiple columns?
Date: 2004-09-16 06:24:27
Message-ID: 0F3BF52D-07A9-11D9-8DD7-000D93AE0944@sitening.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

You'll probably need a sequence per thread. A sequence is not
necessarily tied to a column.

-tfo

On Sep 12, 2004, at 11:16 AM, Nick wrote:

> This is actually a table that holds message threads for message
> boards. Column A is really 'message_board_id' and column B is
> 'thread_id'. I would like every new thread for a message board to have
> a 'thread_id' of 1 and increment from there on. -Nick

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Leonardo Francalanci 2004-09-16 07:29:49 table partitioning
Previous Message Michael Meskes 2004-09-16 06:23:23 Re: ECPG & Mac OS X