Primary Key with auto increment field
I would like to increment one field, depending of the value of the
other. here´s an example:
id variable
1 1
2 1
1 2
2 2
can i do that with the following commands?
SELECT setval('sequence',(SELECT max(id) FROM table)) INTO variable;
insert into table values(variable, ..., ...); ?
Will this be transactional? Cause, they say that setval is a command
that its transactional. Using this way i
don´t will need to use a sequence anymore. Is that correct?
Thanks you all.
x asasaxax wrote:
I would like to increment one field, depending of the value of the
other. here�s an example:
Didn't you just ask this question with practically the same wording a
few days ago?
What was wrong with the answers then? What has changed? What's the
*difference* this time?
Repeating your question won't help, you need to ask something more
specific or at least different if you want a useful answer.
If you did not understand the examples you were given last time (which
it sounds like you didn't given your final message) then I strongly
suggest AVOIDING this approach. It is complex, and the solutions
suggested to you require you to understand some PL/PgSQL and a bit about
how locking is used. Are you SURE you can't just use a normal sequence
instead?
--
Craig Ringer