I have the following statement in a trigger: new.email = lower(new.email); When I try to update a record without setting the email column however, I get an error: SQL Error [42703]: ERROR: record "new" has no field "email" I have seen some hacks suggesting TRY/CATCH or converting to a JSON and checking if the field exists, but I would think that there's a better way to check if the field is in the NEW record, no? Any ideas? Thanks! Igal Sapir
|