Re: Sequences

From: Artacus <artacus(at)comcast(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Sequences
Date: 2008-06-19 07:20:08
Message-ID: 485A08A8.70306@comcast.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


>
> I want to create a sequence that increases in unit column 3 for each
> record individually in column 2
>
> How do i create a sequence that can manage this?
> Is there a solution for this?
>
Yeah, depesz shows how to do this here
http://www.depesz.com/index.php/2007/08/17/rownum-anyone-cumulative-sum-in-one-query/

In response to

  • Sequences at 2008-05-03 19:35:41 from Oscar Uribe

Browse pgsql-general by date

  From Date Subject
Next Message David 2008-06-19 07:39:38 Re: Database design: Storing app defaults
Previous Message David 2008-06-19 07:19:45 Re: Database design: Storing app defaults