incrementing values

From: "Dan Harrington" <dan(at)harringtons(dot)net>
To: <dan(at)harringtons(dot)net>
Subject: incrementing values
Date: 2000-12-20 02:14:47
Message-ID: PPELIKJMPHIIPOBOPEKGIEINDCAA.dan@harringtons.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-announce pgsql-general pgsql-hackers

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

In response to

Browse pgsql-announce by date

  From Date Subject
Next Message Corporate Communications 2000-12-22 17:32:41 PostgreSQL, Inc. Releases Open Source Replication & Database Conversion Tools
Previous Message Jeff MacDonald 2000-12-19 19:12:37 Writing about PostgreSQL

Browse pgsql-general by date

  From Date Subject
Next Message Dan Wilson 2000-12-20 02:24:33 Re: grant a db
Previous Message Oliver Elphick 2000-12-19 23:46:59 Re: Character encoding problem using Tcl

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2000-12-20 02:48:09 Re: Re: [HACKERS] Trigger
Previous Message Steve Howe 2000-12-20 02:02:15 Re: OID Implicit limit