Auto increment/sequence on multiple columns? - Mailing list pgsql-general

From nboutelier@hotmail.com (Nick)
Subject Auto increment/sequence on multiple columns?
Date
Msg-id ce0d844c.0409101632.4d648dd8@posting.google.com
Whole thread Raw
Responses Re: Auto increment/sequence on multiple columns?  (Thomas F.O'Connell <tfo@sitening.com>)
List pgsql-general
Is it possible to have a sequence across two columns. For example

table1
+---+---+
| a | b |
+---+---+
| 1 | 1 |
| 1 | 2 |
| 1 | 3 |
| 2 | 1 |
| 2 | 2 |
| 2 | 3 |
| 3 | 1 |
| 3 | 2 |
| 3 | 3 |
+---+---+

Would I have to create a new sequence for every unique 'a' column?
That seems pretty tedious. -Nick

pgsql-general by date:

Previous
From: Greg Stark
Date:
Subject: Re: Salt in encrypted password in pg_shadow
Next
From: Alex Soto
Date:
Subject: help turning of NOTICE messages