Hot answers tagged

1

The updated or inserted row is referenced using the new record: CREATE OR REPLACE FUNCTION trigger_fct_tri_sv_tab_temp() RETURNS trigger AS $BODY$ BEGIN new.FLAT := UPPER(new.FLAT); RETURN NEW; end $BODY$ LANGUAGE plpgsql SECURITY DEFINER;


1

There are 4x different RDBMS products under the Sybase name ... Adaptiver Server Enterprise (ASE), SQLAnywhere, IQ and Advantage. The 4x products do not share a common SQL language/syntax. The question references a link for the create trigger syntax in ASE. The sample code in the question appears to also be for ASE. However, from the comments we've ...


Only top voted, non community-wiki answers of a minimum length are eligible