Backend data validation and error

francis_mat

Hi,

I want to validate a few fields before saving and abort if the validation failed.

I wrote a code
IF (TG_OP = 'INSERT') or (TG_OP <> 'DELETE') THEN
if (NEW.(frn_hospitality_management.frn_bookings.bookingdate) > now) then
instance.abort_show_message("ERROR: Booking date cannot be in the future...");
end if;
END IF;

But when I try to save, I get the following error message

What am I doing wrong?

Cheers
Francis

lsw-fabian

francis_mat Postgres doesnt know what to do with your function call.
instance.abort_show_message("ERROR: Booking date cannot be in the future...");

If you only want to execute an function without using the return value, you have to add 'PERFORM' in front of it - In your case:
IF (TG_OP = 'INSERT') or (TG_OP <> 'DELETE') THEN if (NEW.(frn_hospitality_management.frn_bookings.bookingdate) > now) then PERFORM instance.abort_show_message('ERROR: Booking date cannot be in the future...'); end if; END IF;

I think that will fix the issue for you.

gabriel

If you are calling a function without receiving the return value, you would use the PERFORM keyword, such as this:
PERFORM instance.abort_show_message(...