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