Fw: Clipping values

From: Ovid <curtis_ovid_poe(at)yahoo(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Fw: Clipping values
Date: 2010-03-24 16:30:56
Message-ID: 859249.9789.qm@web65711.mail.ac4.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

In response to a private email from someone else on this list, I thought I should send the following clarification.

I have a table with four values which are constantly lowered by user action. These four values must rise over time, in five minute intervals. The core of the function, in pseudo-code, would look something like this:

FOREACH row IN SELECT * FROM some_table WHERE some_percentages are less than 1
LOOP
new_percentage = num_intervals * .1 > 1
? 1
: num_intervals * .1;
UPDATE some_table SET some_percentages = new_percentage WHERE id = row.id
END LOOP

But, of course, doing that for four percentages (with at least one having a different increment value than .1)

Cheers,
Ovid

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2010-03-24 16:37:28 Re: Revoking CREATE TABLE
Previous Message Tony Webb 2010-03-24 16:28:37 Re: Revoking CREATE TABLE