Re: Inc - Mailing list pgsql-sql

From Ezequias Rodrigues da Rocha
Subject Re: Inc
Date
Msg-id 55c095e90703061109g334af305n5644a7cb10ad4c2@mail.gmail.com
Whole thread Raw
In response to Re: Inc  (Richard Huxton <dev@archonet.com>)
List pgsql-sql
I did like this:

update base.destinationTable set MyCountField = MyCountField + 1 where
id = new.keyField_ID;

I think it works becouse my tests are ok.

My really thank you all.

Ezequias
2007/3/6, Richard Huxton <dev@archonet.com>:
> Ezequias Rodrigues da Rocha wrote:
> > Thank you but I must inc an specific row. How to do that ?
>
> I'm not sure I understand. A row in a different table?
>
> ...
> BEGIN
>      UPDATE some_table SET counter = counter + 1;
> END;
> ...
>
> --
>    Richard Huxton
>    Archonet Ltd
>


pgsql-sql by date:

Previous
From: Oleg Bartunov
Date:
Subject: Re: GiST index question: performance
Next
From: Gerardo Herzig
Date:
Subject: best index for ~ ordering?