trigger question

Hi!
Could someone tell me, how to write a trigger that updates index of a new row in table with next sequence number, please ? I mean, that i have a table, a sequence, and I want to create a trigger, that fires when I add a new row to this table and updates index column in added row (like autonumber or serial type in other databases)

thanks for help

Marek Budyn Received on Fri Sep 21 2001 - 14:55:32 CDT