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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general