incrementing values - Mailing list pgsql-general

From Dan Harrington
Subject incrementing values
Date
Msg-id PPELIKJMPHIIPOBOPEKGIEINDCAA.dan@harringtons.net
Whole thread Raw
In response to PostgreSQL, Inc. Open Letter to the PostgreSQL Global Development Project  (Geoff Davidson <geoff@sales.org>)
List pgsql-general
Hello,

Is there a way to increment a record using an SQL command to make a
"ranking" method
for values?

i.e. When I select one result (one record) from an SQL query, I want to be
able to alter an
integer record that is associated with that record so that I can order the
results
from the next SQL query based on the integer value.

got that? :-) heh

image    title    | URL    |keywords    |101
image    title    | URL    |keywords    |101
image    title    | URL    |keywords    |101
image    title    | URL    |keywords    |101
image    title    | URL    |keywords    |101
image    title    | URL    |keywords    |101
image    title    | URL    |keywords    |101
image    title    | URL    |keywords    |101
image    title    | URL    |keywords    |101


pgsql-general by date:

Previous
From: Matt Beauregard
Date:
Subject: Re: increment/rank
Next
From: "Gregory Wood"
Date:
Subject: Re: PL/pgSQL Trigger Problems