Re: simple trigger question ... - Mailing list pgsql-sql

"Marc G. Fournier" <scrappy@hub.org> writes:
>> Er ... you just want to bump the sequence and throw away the actual
>> value?  You don't want to store the value somewhere?

> Correct

Then you need something like (untested)

CREATE FUNCTION mytrig() RETURNS TRIGGER AS '
begin perform nextval(''seq''); return new;
end' LANGUAGE plpgsql;
        regards, tom lane