From: PFC <lists@peufeu.com>
To: pgsql-sql@postgresql.org
Subject: Re: Update counter when row SELECT'd ... ?
Date: Tue, 21 Mar 2006 09:56:14 +0100
Message-ID: <op.s6q9r0w2cigqcu@apollo13> (raw)
In-Reply-To: <0IWG005D0KJNGPE0@VL-MH-MR002.ip.videotron.ca>
References: <0IWG005D0KJNGPE0@VL-MH-MR002.ip.videotron.ca>
On Tue, 21 Mar 2006 04:33:22 +0100, Daniel CAUNE <d.caune@free.fr> wrote:
>> I have a simple table:
>>
>> name, url, counter
>>
>> I want to be able to do:
>>
>> SELECT * FROM table ORDER BY counter limit 5;
>>
>> But, I want counter to be incremented by 1 *if* the row is included in
>> that 5 ... so that those 5 basically move to the bottom of the list, and
>> the next 5 come up ...
>>
>> I've checked CREATE TRIGGER, and that doesn't work 'ON SELECT' ... is
>> there anything that I *can* do, other then fire back an UPDATE based on
>> the records I've received?
>>
>> Thanks ...
>>
You could also have a "new" table (which gets new rows) and an "archive
table", and move the rows from "new" to "archive" while selecting them,
using a plpgsql set-returning function .
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: lists@peufeu.com
Subject: Re: Update counter when row SELECT'd ... ?
In-Reply-To: <op.s6q9r0w2cigqcu@apollo13>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox