Set binary column dependent on cumulative value of integer column

From: "Markus Juenemann" <markus(at)juenemann(dot)net>
To: pgsql-sql(at)postgresql(dot)org
Subject: Set binary column dependent on cumulative value of integer column
Date: 2006-12-01 13:37:55
Message-ID: 9d8bdcf30612010537o772b7aadu9c6e9125cdbc0d79@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi

I've got a bit of a tricky (or me!) problem. The example below is
completely ficticious but
describes my real problem in a way which might be easier to understand.

Imagine your table contains

CREATE TABLE passenger_queue (
id serial NOT NULL,
name character varying(40) NOT NULL,

Browse pgsql-sql by date

  From Date Subject
Next Message Markus Juenemann 2006-12-01 13:50:37 Setting boolean column based on cumulative integer value
Previous Message A. Kretschmer 2006-12-01 06:56:20 Re: retrieve row number