Re: [GENERAL] A question about inheritance and sequence

> Triggers are generally more robust. Quick example: > NEW.noteid := SELECT 1+ COALESCE( (SELECT noteid FROM "Notes" WHERE > userkey=NEW.userkey ORDER BY noteid DESC LIMIT 1), 0 ); Can you please write me the whole trigger? I've been reading the manual for an hour and I have no idea in where to a

[GENERAL] A question about inheritance and sequence

ave to make nested queries and where would I do it? Thank you for help. Regards, Marko Pahić