Re: Copying rows
From: (wrong string) åten <mobra_at_statoil.com>
Date: 1998/12/17
Message-ID: <36791BCE.84C931E5_at_statoil.com>#1/1
Date: 1998/12/17
Message-ID: <36791BCE.84C931E5_at_statoil.com>#1/1
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