Triggers... Questions... Yes.

I just used Dezign for Databases and created a simple table in what it
claimed was "ANSI Level 2" compliance with a one-up "autonum" column.

It spewed forth the following code:

 -- file generated by "dezign for databases"
 -- create-date    :6/13/2002
 -- create-time    :10:29:56 am
 -- project-name   :not yet specified
 -- project-author :not yet specified

 create table transaction(autonum integer);

 create trigger transaction_autonum_inc
 before insert on transaction
 referencing new as n
 for each row
 set (n.autonum) = (select (max(autonum),0) + 1 from transaction);

Postgres (as you might suspect) didn't like it. Looking at the Postgres
"create trigger" syntax, there is nothing about "referencing X as Y" being
a possible phrase.

Is the problem in:

1. Dezign for Databases, this really isn't ANSI Level 2,
2. Postgres, it doesn't (yet) support this level of functionality, but
   should, or
3. Me, I'm mixing up ANSI Level 2 and ANSI SQL '92, Postgres doesn't now
   and has no plans to support ANSI Level 2 SQL

???

Thanks,
Tim Ellis
DBA, Gamet