Re: Inc

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