Re: Copying rows

Russ Whiteman wrote:

> You could use a before_insert trigger on the table to whatever value is in
> the primary key column with the next sequence number, then your query would
> not need to specify column names. This has the downside of assuming that
> you always want duplicate row inserts to succeed, but nothing's perfect.

How would I construct this trigger? I want to be able to insert "normal" rows as well.

• Morten