From: Anthony Best <abest@digitalflex.net>
To: pgsql-general@postgresql.org
Subject: Sequence question.
Date: Tue, 16 Dec 2003 18:12:47 -0700
Message-ID: <3FDFAD8F.5080404@digitalflex.net> (raw)
I'm working on an idea that uses sequences.
I'm going to create a table like this:
id serial,
sequence int,
keyword varchar(32),
text text
for every keyword there will be a uniq sequence for it eg:
id, sequence, keyword
1, 1, foo, ver1
2, 1, bar, bar ver1
3, 2, foo, ver2
4, 2, bar, bar ver2
etc...
I could have one sequence for all keyword which would be 1,3, etc... I
would be prefer to have them in sequence. I'm sure someone has ran into
this before, any ideas?
Anthony.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-general@postgresql.org
Cc: abest@digitalflex.net
Subject: Re: Sequence question.
In-Reply-To: <3FDFAD8F.5080404@digitalflex.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox