silly_sad wrote:
id default value is always set by the trigger before insert on each
table for each row.
The particular subproblem is to
insert one record into ttt1
and then insert corresponding record into ttt,
___This is the place to use currval.
I'd be tempted to turn it the other way around and have an AFTER trigger
that just uses NEW.id as the value to put into "ttt".
The reason to use an AFTER trigger is that you know the value can't be
changed at that point, whereas with a BEFORE trigger it might. In your
case it doesn't matter, but it's probably a good idea to be consistent
in these things.
--
Richard Huxton
Archonet Ltd
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
