From: | "Ezequias Rodrigues da Rocha" <ezequias(dot)rocha(at)gmail(dot)com> |
---|---|
To: | "Richard Huxton" <dev(at)archonet(dot)com> |
Cc: | PostgreSQL <pgsql-sql(at)postgresql(dot)org> |
Subject: | Re: Inc |
Date: | 2007-03-06 17:29:03 |
Message-ID: | 55c095e90703060929w745cd560g12426c986b75e430@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
Thank you but I must inc an specific row. How to do that ?
Ezequias
2007/3/6, Richard Huxton <dev(at)archonet(dot)com>:
> Ezequias Rodrigues da Rocha wrote:
> > Hi list,
> >
> > There is any function to increment with 1 some field.
> >
> > For example. I have a table with a field that on each update it
> > incrementes a field that is allways configured to 0 before the
> > starting of updates.
>
> Something like:
>
> CREATE FUNCTION my_autoinc() RETURNS TRIGGER AS $$
> BEGIN
> NEW.counter := NEW.counter + 1;
> RETURN NEW;
> END;
> $$ LANGUAGE plpgsql;
>
> CREATE TRIGGER my_counter_trig BEFORE UPDATE ON my_table
> FOR EACH ROW EXECUTE PROCEDURE my_autoinc();
>
> --
> Richard Huxton
> Archonet Ltd
>
--
Ezequias Rodrigues da Rocha
http://ezequiasrocha.blogspot.com/
use Mozilla Firefox:http://br.mozdev.org/firefox/
From | Date | Subject | |
---|---|---|---|
Next Message | Richard Broersma Jr | 2007-03-06 17:40:49 | Re: Inc |
Previous Message | Richard Huxton | 2007-03-06 17:13:29 | Re: Inc |